cancel the current transaction - Maple Help

Online Help

All Products    Maple    MapleSim

Home : Support : Online Help : Connectivity : Database Package : Connection : Database/Connection/Rollback

Connection:-Rollback - cancel the current transaction

Calling Sequence

connection:-Rollback( )




Connection module



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.


Execute an update.


conn:=driver:-OpenConnectionurl,name,pass:conn:-ExecuteUpdateINSERT INTO animals( id, name, number, mass ) VALUES( 11, 'chicken', 15, 2.1 ):conn:-ExecuteUpdateINSERT INTO animals( id, name, number, mass ) VALUES( 12, 'cow', 2, 513 ):

Calling Rollback cancels all the uncommitted changes.

conn:-Rollback;conn:-ExecuteQuerySELECT * FROM animals WHERE id > 10,output='Array'


See Also

Database, Database[Connection], Database[Connection][Commit], Database[Connection][CreatePreparedStatement], Database[Connection][CreateStatement], Database[Connection][ExecuteUpdate], Database[Statement], Database[usage]

Download Help Document

Was this information helpful?

Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam