LOTUS CONNECTORS

CommitOnDisconnect property
Read-write. Indicates whether pending transactions are committed or rolled back on disconnect.

Defined in

ODBCConnection

Data type

Boolean

Syntax

To get: flag% = odbcConnection.CommitOnDisconnect

To set: odbcConnection.CommitOnDisconnect = flag%

Legal values


Usage

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