STRANGE error Error # 1585 Update conflict on line with Requery() if and **ONLY** if I replace a datetime() field. It will run down through 8 or 10 records and then locks up (with error 1585). If I comment out that line (as shown below) it runs through several thousand records with NO PROBLEM.

How can that be a conflict????

Using VFP 6 and SQL 7

My application replaces the data in a few of the SQL fields using a remote view.

Code

Store datetime() to xdate

SELE e &&remote view of SQL table
=Requery() && I have set the memory variable for the unique record and it **DOES find the unique SQl record
IF reccount()=1
*REPLACE e.nopicdate with xdate
REPLACE e.donotpic with .t.
REPLACE e.accessfee with .f.
REPLACE e.nopicreason with 25
=tableupdate()


The Datetime() filed IS the problem.

TANKS