advr.hlp (Topic list)
Important Notice
The pages on this site contain documentation for very old MS-DOS software, purely for historical purposes. If you're looking for up-to-date documentation, particularly for programming, you should not rely on the information found here, as it will be woefully out of date.
ROLLBACK Statement Details
  ◄Summary►  ◄Details►  ◄Example►                ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
 ROLLBACK [ALL | savepoint%]
 
 Usage Notes
   ■ Use SAVEPOINT to designate a savepoint, which marks the beginning of a
     subset of operations that can be rescinded. See: ◄SAVEPOINT Function►
 
   ■ If you specify a savepoint% argument, ROLLBACK returns the data
     affected by the transaction to its state at that savepoint.
 
   ■ If you do not specify a savepoint% argument, ROLLBACK returns the data
     affected by the transaction to its state at the previous savepoint, or
     at the beginning of the transaction if there are no intermediate
     savepoints.
 
   ■ ROLLBACK ALL rescinds all ISAM operations in a transaction and returns
     the data to its initial state at the beginning of the transaction.
 
   ■ Use BEGINTRANS to indicate the beginning of a transaction.
     See: ◄BEGINTRANS Statement►
 
   ■ Use COMMITTRANS to commit all operations since the most recent
     BEGINTRANS. See: ◄COMMITTRANS Statement►