Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Update Conflict - wrong ID #!
Hi,
I am using VFP6.0 and SQL Server 7.0.
I get an Update Conflict error when attempting to update a remote view, when a user changes a record, with a TableUpdate(). Actually, when I go into debug at a point before the Begin Transaction starts, and the TableUpdate() and try to browse the view, I also get the error.
I have researched the view and found that the ID Number field that VFP is trying to update is an ID number from a different view on a different table!! That ID number does NOT exist in the view I am trying to update, yet I get that error (which is a good thing I think because it is the wrong ID number).
The remote view I am trying to update only has the ID number as the primary key, and it, nor the timestamp field, is selected as updatable. Send SQL updates is selected and if I uncheck that, I of course don't get the error.
Any ideas? Let me know if any one needs more specifics, or code posted.
Thanks,
-paul
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