COMMIT( )

Topic group Related topics

Clears the transaction log, committing all logged changes.

Syntax

COMMIT([<database name expC>])

<database name expC>

The name of the database in which to complete the transaction.

If you began the transaction with BEGINTRANS(<database name expC>), you must issue COMMIT(<database name expC>). If instead you issue COMMIT( ), dBASE Plus ignores the COMMIT( ) statement.

If you began the transaction with BEGINTRANS( ), <database name expC> is an optional COMMIT( ) argument. If you include it, it must refer to the same database as the SET DATABASE TO statement that preceded BEGINTRANS( ).

Description

A transaction works by logging all changes. If an error occurs while attempting one of the changes, or the changes need to be undone for some other reason, the transaction is canceled by calling ROLLBACK( ). Otherwise, COMMIT( ) is called to clear the transaction log, thereby indicating that all the changes in the transaction were committed and that the transaction as a whole was posted.

For more information on transactions, see BEGINTRANS( ).

OODML

Call the commit( ) method of the Database object.