<Connection variable>.TransactionRollbackToSavepoint (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.TransactionRollbackToSavepoint (Function)

In french: <Variable Connexion>.TransactionRetourneAuPointDeSauvegarde

Rolls the transaction back to the savepoint.

Example

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>: Connection variable

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

Component: wd300hf.dll