This item was deprecated in version 2019r2. Please use Database.CommitTransaction as a replacement.
Commits an open transaction. This permanently saves changes to the database.
You have to have an open transaction to be able to use Commit. On SQLite (and other databases), you can start a transaction with this command:
It can be sent using SQLExecute:
You typically want to Commit changes after ensuring there were no database errors:
// Prior DB code has run If Not DB.Error Then DB.Commit Else MsgBox("Error: " + DB.ErrorMessage) DB.Rollback End If
All project types on all supported operating systems.