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.