Greetings,

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.

Any ideas?

Greg