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