General information
Category:
Coding, syntax & commands
I wish to update a table using the SQL Update command. I wish to replace a field in the table with a value located in a temporary cursor:
UPDATE LiveTable SET f02AID = temp.tm_new_aid;
WHERE LiveTable.f02AID in select(temp.f02AID from temp where; temp.tm_chg = "Y")
Table temp contains the old ID (f02AID) and the new ID (tm_new_aid)
This doesn't seem to work as I get a number of changes that result in a new ID of blank.
Anyone have a technique for this?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only