Online Help

Rollback cancels the current transaction and discards all the changes in the current transaction. After Rollback has been called a new transaction is in effect.

The current transaction can be committed by calling Commit .

$\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(\; 11,\; \text{'}chicken\text{'},\; 15,\; 2.1\; )''\right)\:$$\mathrm{conn}:-\mathrm{ExecuteUpdate}\left(''INSERT\; INTO\; animals(\; id,\; name,\; number,\; mass\; )\; VALUES(\; 12,\; \text{'}cow\text{'},\; 2,\; 513\; )''\right)\:$

$\mathrm{conn}:-\mathrm{Rollback}\left(\right)\;$$\mathrm{conn}:-\mathrm{ExecuteQuery}\left(''SELECT\; *\; FROM\; animals\; WHERE\; id\; >\; 10''\,\mathrm{output}='\mathrm{Array}'\right)$