UPDATE v_zips ;
    SET dealerid = zips.dealerid ;
  FROM v_zips ;
  JOIN zips ON zips.zipcode == v_zips.zipcode

>
>I've got a VERY simple bit of code:
>
>

>SELECT v_zips
>SCAN
>	SELECT zips
>	LOCATE FOR zips.zipcode == v_zips.zipcode
>	IF !EOF()
>	    SELECT v_zips
>	    replace v_zips.dealerid WITH zips.dealerid
>	ENDIF
>	
>ENDSCAN
>

>
>Basically this is just to update a database server with changes to with dealer is tied to a zip code.
>
>I get an update conflict when it tries to move to the second record in the scan.
>
>Now here is the weird part. You can change data in the browse window of v_zips just fine. Even more weird, you can type the replace command in the command window and then skip off the record and it updates just fine. I did the manual operation in the command window ten times with no conflicts.
>