>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
Joel,
Check if xdate is nonempty and if it's check if there are any constraints set on SQL server table that would deny the change.
Cetin