General information
Category:
Coding, syntax & commands
Title:
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")
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