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