advr.hlp (Topic list)
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.