>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?

You can do such UPDATE in VFP9 with FROM clause. In previous versions you can use kludgy way as shown in Re: GATHER NAME vs APPEND Message #914947