Commit closes the current transaction and applies all the changes to the database.  After Commit has been called, a new transaction is in effect.

The current transaction can be canceled by calling Rollback.

Depending on the transaction isolation of the current Connection, updates made within a transaction may not be visible to other processes accessing the database until the changes are committed.  For more information about transaction isolation, see SetOptions.

$\mathrm{driver}≔\mathrm{Database}\left[\mathrm{LoadDriver}\right]\left(\right)\:$

$\mathrm{conn}≔\mathrm{driver}:-\mathrm{OpenConnection}\left(\mathrm{url}\,\mathrm{name}\,\mathrm{pass}\right)\:$$\mathrm{conn}:-\mathrm{ExecuteUpdate}\left(''INSERT\; INTO\; animals(\; id,\; name,\; number,\; mass\; )\; VALUES(\; 12,\; \text{'}cow\text{'},\; 2,\; 513\; )''\right)\:$

$\mathrm{conn}:-\mathrm{Commit}\left(\right)$