>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...
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement