>I'm having a problem with a remote view of a MS SQL Server table. The table has three key fields (integer, integer, and datetime).
>
>The table contains 58 records. I can successfully update 45 records, but 13 records are giving me a problem. If I attempt to save changes to these records, I get an Update Conflict error. This occurs regardless of the field I am attempting to update.
>
>If I delete the records and rekey the exact same data, the problem goes away.
>
>Any ideas?
>
>Jeff
I've heard on FoxTeach that there is a bug with the where clause (TIMESTAMP) in the view designer. The datetime in SQL SERVER and Visual FoxPro is not exactly the same.
Try to change the WHERE clause to KEY AND MODIFIED FIELDS instead of KEY FIELD AND TIMESTAMP...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only