Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you ROLLBACK a view
Message
From
04/03/1998 12:27:29
Edward Crawford
City Facilities Management
Glasgow, United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How do you ROLLBACK a view
Miscellaneous
Thread ID:
00082524
Message ID:
00082524
Views:
69
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
Map
View

Click here to load this message in the networking platform