General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ROLLBACK doesn't return table to previous state?
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
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