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();
Published date: 05/24/2022
Last modified date: 02/24/2022
