TransactionSetSavepoint

Sets a savepoint in the current transaction.

This savepoint can then be a rollback point when executing a rollback via transactionRollback( "mySavepointName" ).

Method Signature

TransactionSetSavepoint(savepoint=[string])

Arguments

Argument	Type	Required	Description	Default
savepoint	string	true	Specify a savepoint name.

Examples

Using TransactionSetSavepoint with TransactionRollback

Here's a simple example of using multiple savepoints within a transaction:

transaction {
    queryExecute( "INSERT INTO vehicles (id,make) VALUES (8, 'Ford' )", {}, { datasource : "carDB" } );
    transactionSetSavepoint( 'insert' );

    queryExecute( "UPDATE developers SET name = 'Chevrolet' WHERE id=8", {}, { datasource : "carDB" } );
    transactionSetSavepoint( 'update' );

    // more stuff ...
    transactionRollback( 'insert' );
}

In this example, the UPDATE will be rolled back while the INSERT statement will remain. Remember that in transactionRollback(), the savepoint is not the name of a single savepoint to roll back, but the name of the savepoint to rollback TO.

Roll back to a specified savepoint

This example runs multiple queries with a savepoint for each, and rolls back to the 'useradded' savepoint if the last query fails.

Run Example

bx:transaction {
	// insert user
	transactionSetSavepoint( "useradded" );
	try {
	}
	// another query
	 catch (any e) {
		transactionRollback();
	}
}

Related

• IsInTransaction

• IsWithinTransaction

• PreserveSingleQuotes

• QueryExecute

• TransactionCommit

• TransactionRollback