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( )

Parameters

connection

-

Connection module

Description

• 

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.

Examples

Execute an update.

driver:=Database[LoadDriver]:

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'

(1)

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