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