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.
COMMITTRANS Statement Details
  ◄Summary►  ◄Details►  ◄Example►                ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
 COMMITTRANS
 
 Usage Notes
   ■ Transactions are a way to group a series of ISAM operations so that you
     can commit them as a whole, rescind them all, or rescind operations
     since a designated savepoint.
 
   ■ COMMITTRANS commits only ISAM operations. It does not affect other Basic
     variables or file types.
 
   ■ Use BEGINTRANS to indicate the beginning of a transaction.
     See: ◄BEGINTRANS Statement►
 
   ■ Use the SAVEPOINT function to designate a savepoint.
     See: ◄SAVEPOINT Function►
 
   ■ Use the ROLLBACK and ROLLBACK ALL statements to rescind all or part of
     a transaction's operations. See: ◄ROLLBACK Statement►
 
   ■ If there is no transaction pending, Visual Basic generates the error
     message, "Illegal function call."
 
   ■ Any ISAM operation that closes a table causes transactions to be
     committed. For example, if a type mismatch occurs while you are opening
     an ISAM table, the table is closed and a pending transaction is
     committed.
 
   ■ You may wish to code your programs so they first open all tables, then
     perform all transactions, then close tables. Make sure any operation
     that can close a table occurs outside a transaction.