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: ``` xojo BEGIN TRANSACTION ``` It can be sent using SQLExecute: ``` xojo DB.SQLExecute("BEGIN TRANSACTION") ``` ## Sample code You typically want to Commit changes after ensuring there were no database errors: ``` xojo ' 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`