Defined in

ODBCConnection

Data type

Boolean

Syntax

To get: flag% = odbcConnection.CommitOnDisconnect

To set: odbcConnection.CommitOnDisconnect = flag%

Legal values

• True indicates that transactions will be committed on disconnect.
• False indicates that transactions will be rolled back on disconnect.

When the back-end database is in auto-commit mode, all changes are automatically and permanently made at the time of a successful UpdateRow or DeleteRow. If the database is in transaction mode, the changes may be rolled back or committed later, including at the time of disconnection.

If you want to commit updates when you disconnect from the data source, you must set CommitOnDisconnect to True; in addition, set the AutoCommit property to False.

See Also

AutoCommit property
CommitTransactions method
RollbackTransactions method

Glossary