UltraLite ActiveX User's Guide
Understanding UltraLite ActiveX Development
Accessing and manipulating data using the table API
UltraLite provides transaction processing to ensure the integrity of the data in your database. A transaction is a logical unit of work: either the entire transaction is executed, or none of it is executed.
By default, UltraLite operates in AutoCommit mode. In AutoCommit mode, each insert, update, or delete is executed as a separate transaction. Once the operation is completed, the change is made to the database.
If you set the ULConnection.AutoCommit property to false, you can use multi-statement transactions. For example, if your application transfers money between two accounts, the deduction from the source account and the addition to the destination account constitute a single transaction.
If AutoCommit is set to false, you must execute a ULConnection.Commit statement to complete a transaction and make changes to your database permanent, or you must execute a ULConnection. Rollback statement to cancel all the operations of a transaction.
NoteSynchronization causes an AutoCommit even if you have AutoCommit set to False. |
Turning AutoCommit off improves performance.