From Xojo Documentation
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)