Information générale
Titre:
...uncommitted changes???
I have a view that I am having trouble with. When I attempt to save changes (adding a new record or editing an existing one) I get the error...
Table buffer for alias vpieces contains uncommitted changes.
... this error is hitting on the Requery command... here's the code I have in my save button click method...
SELECT vPieces
BEGIN TRANSACTION
IF ThisForm.AddMode
REPLACE keylink WITH ThisForm.CurrKeyLink
REPLACE created WITH DATETIME()
REPLACE createdby WITH oApp.CurrentUser
ENDIF
=TABLEUPDATE(.T.)
END TRANSACTION
=REQUERY('vPieces')
... where the keylink is the key field in the table. I have tried several versions of this code but it always gives the uncommitted changes error on the requery.
In the DBC I have the Update Criteria on the view set to "Send SQL updates", with the keylink set as the key, all the other fields have update checked, and the remaining settings are set to default.
Any ideas why I'm getting this error?
Thanks!
Mark
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