Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
How do you ROLLBACK a view
I have 2.6 tables that I need to be able to place in a tranaction and be able to roll back. You can't rollback a table that is not a member of a database container, but Jim Booth pointed out to me that I could use an Updateable view. What is the procedure for rolling back an updateable view? Here is roughly what I am doing, but it doesn't seem to work:
TableA (2.6 table)
ViewA (Updateable view made up of fields from TableA)
CURSORSETPROP("buffering", 5, "TableA")
BEGIN TRANSACTION
IF !UpdateTableA()
llSuccess = .F.
ENDIF
IF !UpdateTableB()
llSuccess = .F.
ENDIF
IF !UpdateTableC()
llSuccess = .F.
ENDIF
IF llSuccess = .T.
ENDTRANSACTION
ELSE
ROLLBACK
ENDIF
********************
Method UpdateTableA (UdateTableB and UpdateTableC the same)
SELECT ViewA
APPEND BLANK
REPLACE ViewA.Field1 WITH "Test",
ViewA.Field2 WITH "Test2"
TABLEUPDATE(0,.T., "TableA")
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