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.