Method
Database_Class.Commit
Warning
This item was deprecated in version 2019r2. Please use Database.CommitTransaction as a replacement.
Description
Commits an open transaction. This permanently saves changes to the database.
Notes
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:
BEGIN TRANSACTION
It can be sent using SQLExecute:
DB.SQLExecute("BEGIN TRANSACTION")
Sample code
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
Compatibility
All project types on all supported operating systems.
See also
Database parent class; Database.Close, Database.RollbackTransaction