>>Sorry to jump in here, but there is no FROM clause in the UPDATE command in version 8.0.
>>
>>--------
>>
>>I suggest a more conventional way.
>>
>>1. Create an index on the ID field of the _tmp cursor.
>>
>>SELECT _tmp
>>INDEX ON id TAG id
>>
>>
>>2. Execute this code
>>
>>SELECT Table1
>>SET RELATION TO id INTO _tmp
>>replace ALL table1.field1 WITH _tmp.field1
>>SET RELATION TO
>>
>>
>>The relationship will move the _tmp cursor record pointer to always match up it's ID with the Table1 ID.
>>
>>
>
>
>Hi Greg,
>Thanks for response. I thought "FROM" just a little misstype and remove it when I test .. this SQL expression not works .. maybe in VFP9 with "from" it will work.. I have not idea.. I have not VFP9.
I don't have 9.0 with me here
>
>About SET RELATION TO.. nice suggestion.. I need to compare performace with scan all
> replace for id ...
>I thinking with relation it must work faster
I think it would.
Greg Reichert