Database.Commit
From Xojo Documentation
This item was deprecated in version 2019r2. Please use Database.CommitTransaction as a replacement. |
Method
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
If Not DB.Error Then
DB.Commit
Else
MsgBox("Error: " + DB.ErrorMessage)
DB.Rollback
End If