bas7advr.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, ROLLBACK ALL Statements Details
  Syntax  Details  Example                 Contents  Index  Back
──────────────────────────────────────────────────────────────────────────────
ROLLBACK and ROLLBACK ALL rescind all or part of the operations of a
transaction (a series of ISAM database operations).
 
ROLLBACK [savepoint%]
ROLLBACK ALL
    ■ The argument savepoint% is a number that identifies a savepoint
      within a transaction--a series of ISAM database operations that
      is either committed as a whole or rescinded.
    ■ Use SAVEPOINT to designate a savepoint, which marks the beginning
      of a subset of operations that can be rescinded.
 
Usage Notes
    ■ 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.
    ■ Use COMMITTRANS to commit all operations since the most recent
      BEGINTRANS.