From Xojo Documentation
Commits an open transaction. This permanently saves changes to the database.
|DatabaseException||Raised if the transaction could not be committed.|
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 ExecuteSQL:
You typically want to Commit changes after ensuring there were no database errors:
Catch error As DatabaseException
MsgBox("Error: " + error.Message)