Small company logo:
   History
 
Advertising banner:
 
 Connection.AutoCommit
Home • Help • Customization Tools • FCAS • Language Reference • Connection.AutoCommit
 
Purpose
Specifies whether to use autocommit or manual-commit mode.
Syntax
DBConnection.AutoCommit [= Constant]


Constant
Possible values:
SQL_AUTOCOMMIT_OFF
The connection uses manual-commit mode.
The application must explicitly commit or roll back a transaction.
SQL_AUTOCOMMIT_ON
The driver uses autocommit mode.
Each command is committed immediately after it is executed.
SQL_AUTOCOMMIT_DEFAULT
Autocommit On.
If no value for Constant is assigned, the default depends on the settings in your ODBC setup. Changing from manual-commit mode to autocommit mode commits any open transactions on the connection.