Hi Arto,
I cannot even tell if the second one will work w/o running a test. For that reason I would never use it.
I work a lot with MS SQL Server so it's naturall for me to use something that works in both in VFP and MS SQL Server, like UPDATE. The UPDATE may be slow compare to REPLACE...FOR because UPDATE locks record by record and REPLACE...FOR locks a table header.
>Is next preferrable
>UPDATE v_zips ;
> SET dealerid = zips.dealerid ;
> FROM v_zips ;
> JOIN zips ON zips.zipcode == v_zips.zipcode
>
>than
>
>* set order to 0
>replace v_zips.dealerid WITH zips.dealerid ;
> FOR v_zips.zipcode == zips.zipcode IN v_zips
>I have never use UPDATE, I just and just even rember such of command! But is there an advantage to use it - I dont know.
>
>
--sb--