Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ROLLBACK doesn't return table to previous state?
Message
From
30/09/2000 00:18:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ROLLBACK doesn't return table to previous state?
Miscellaneous
Thread ID:
00423028
Message ID:
00423028
Views:
47
I tried to learn about ROLLBACK command. I expected that by issuing ROLLBACK command my table will be back to previous state (discard any changes and appended records) but I was failed. What could be wrong?
Here is my listing:

=cursorsetprop('Buffering',5,'tran') && activate buffering
sele tran
appe blan && add 1st record
repl inv_no with 'test 1'
appe blan && add 2nd record
repl inv_no with 'test 2'
begin tran
=tableup(2,.t.,[tran]) && write changes
roll && cancel changes
brow && new records still exist
*tablere(.t.,'tran') && this is the only way?
Next
Reply
Map
View

Click here to load this message in the networking platform