Auto-Commit Mode

Data Access and SQL > SQL Tables > Run-Time Options > Auto-Commit Mode

Auto-Commit Mode

When the auto-commit mode is enabled, the IliSQLTable object commits the transaction immediately after an INSERT, UPDATE or DELETE operation. When auto-commit is disabled, the transaction must be committed (through the effective SQL session) as required.

Here is an example:

IliSQLTable* sqlTbl;

...

// Delete two rows and then commit.

sqlTbl->setAutoCommit(IlvFalse);

sqlTbl->deleteRow(10);

sqlTbl->deleteRow(9);

sqlTbl->getEffectiveSQLSession()->commit();

Version 5.7