Data Access User Manual > 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 6.0
Copyright © 2015, Rogue Wave Software, Inc. All Rights Reserved.