|
|
|
|
|
|
|
|
<HFSQL connection>.TransactionRollbackToSavepoint (Function) In french: <Connexion HFSQL>.TransactionRetourneAuPointDeSauvegarde Rolls the transaction back to the savepoint. MyConnection is Connection
// Start transactions
MyConnection.TransactionStart()
// Actions A
// Declare a savepoint
MyConnection.TransactionSavepoint("MySavepoint")
// Actions B
// Undo all actions after the declaration of MySavepoint
MyConnection.TransactionRollbackToSavepoint("MySavepoint")
// Actions C
// Declare a savepoint
MyConnection.TransactionSavepoint("MySavepoint2")
// Actions D
// Validate (commit) transactions
// Actions A, C and D are taken into account,
// but not B, because they are between TransactionSavepoint()
// and TransactionRollbackToSavepoint
MyConnection.TransactionEnd()
// MySavepoint2 is disabled
Syntax
<Result> = <Connection>.TransactionRollbackToSavepoint(<Savepoint name>)
<Result>: Boolean - True if rolled back successfully,
- False if a problem occurs. HErrorInfo returns more details about the error.
<Connection>: Control name Name of the Connection variable that describes the connection to an HFSQL server. <Savepoint name>: Character string Name of the savepoint to which the transaction is to be rolled back. If the savepoint does not exist, an error is returned. Remarks - This function must be used in a transaction.
- The corresponding SQL statement can also be used: "ROLLBACK TO SAVEPOINT identifiant".
- This function is not available:
- on HFSQL files in cluster mode,
- with files handled via a Native Connector.
Business / UI classification: Business Logic
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|