Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ROLLBACK doesn't return table to previous state?
Message
De
30/09/2000 00:18:16
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
ROLLBACK doesn't return table to previous state?
Divers
Thread ID:
00423028
Message ID:
00423028
Vues:
48
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?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform