HTransactionRollbackToSavepoint (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HTransactionRollbackToSavepoint (Function)

In french: HTransactionRetourneAuPointDeSauvegarde

Rolls the transaction back to the savepoint.

Example

MaConnexion is Connection

// Début des transactions
HTransactionStart(MaConnexion)

// Réalisation d'actions A

// Déclaration d'un point de sauvegarde
HTransactionSavepoint(MaConnexion, "MonPointDeSauvegarde")

// Réalisation d'actions B

// Annulation de toutes les actions depuis la déclaration de MonPointDeSauvegarde
HTransactionRollbackToSavepoint(MaConnexion, "MonPointDeSauvegarde")

// Réalisation d'actions C

// Déclaration d'un point de sauvegarde
HTransactionSavepoint(MaConnexion, "MonPointDeSauvegarde2")

// Réalisation d'actions D

// Validation (commit) des transactions
// Toutes les actions A, C et D sont prises en compte, 
// mais pas les actions B car elles sont situées entre HTransactionPointDeSauvegarde() 
// et HTransactionRetourneAuPointDeSauvegarde

HTransactionEnd(MaConnexion)

// MonPointDeSauvegarde2 est désactivé

Syntax

<Result> = HTransactionRollbackToSavepoint([<Connection>, ] <Savepoint name>)

<Result>: Boolean

True if the cancellation has been carried out,
False if a problem occurs. HErrorInfo returns more details about the error.

<Connection>: Character string or Connection variable

Connection to an HFSQL server. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.
If this parameter is not specified, the current connection is used.

<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 command is also available: "ROLLBACK TO SAVEPOINT identifier".
This function is not available:
- on HFSQL Cluster data files,
- with files handled via a Native Connector.

Business / UI classification: Business Logic

Component: wd300hf.dll