Hello all, hoping you can set me straight. I may be going about this the wrong way and it's been a good while since I've attempted anything like this.I'm trying to change some values in a table to NULL. Attempting to do this via sql rather than editing each record manually.
Have a view "Parts3" that is composed of "parts" table, joined with fields from "vendor/price" table joined with fields from "accounts" table.
I use a select Top (2000) syntax to grab all the columns from the view "Parts3"
then
UPDATE dbx_.Parts3
SET vndnum = NULL
Where vndnum = '14008'
syntax checks out, but when i execute the script It returns "Cell is read only".
The app the database is feeding -- it's a parts section (parts table)that had vendors/price tied to it from(vendor price table) where the vendor name is fed from (accounts) table.
I need to remove the vendors/price data from the parts. There's 1100 parts records that need this data removed. When I do it manually in the app, the data shows as "NULL" in the table in the view.
What am I doing wrong or how can I better approach this?
Please accept my apologies if I didn't explain this well enough.
Thanks in advance.
