dbx4mysql does fully support transactions as defined in MySQL.
The transactions are mapped by the driver as following:
| dbx4mysql | MySQL server |
|---|
| xilREADCOMMITTED | READ COMMITTED |
| xilREPEATABLEREAD | REPEATABLE READ |
| xilDIRTYREAD | READ UNCOMMITTED |
| xilCUSTOM | SERIALIZABLE |
Please refer to MySQL manual for limitation on each transaction model.
 | MySQL supports two different kinds of tables: transaction-safe tables (InnoDB and BDB) and not
transaction-safe tables (HEAP, ISAM, MERGE, and MyISAM). So, using of transactions is applicable only
with InnoDB and BDB tables. |
Autocommit mode is by default enabled, to disable it you can use:
SQLConnection1.SQLConnection.SetOption(eConnAutoCommit, Integer(False))
