From Xojo Documentation

You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!

Property (As Boolean )
aREALSQLdatabase.AutoCommit = newBooleanValue
BooleanValue = aREALSQLdatabase.AutoCommit

New in 2006r3

Supported for all project types and targets.

Determines whether the database commits changes automatically, or whether changes open an implicit transaction that you must explicitly close by calling Commit or Rollback. The default is False.


A default of False means that a new transaction is started for you when you use a command that modifies the database. To make these changes permanent, you need to issue a Commit after you are finished modifying the database. Use Rollback to cancel the transaction and your changes. Using transactions greatly improves performance of most databases.

If you change this to True, then a Commit will be issued for you after any command that can modify the database. If you are doing a lot of database updates this can dramatically reduce performance.

See Also