From Xojo Documentation
| 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:
If Not DB.Error Then
MsgBox("Error: " + DB.ErrorMessage)