<Connection variable>.TransactionRollbackToSavepoint (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

<Connection variable>.TransactionRollbackToSavepoint (Function)

In french: <Variable Connexion>.TransactionRetourneAuPointDeSauvegarde

Rolls the transaction back to the savepoint.

Example

MaConnexion is Connection

// Début des transactions
MaConnexion.TransactionStart()

// Réalisation d'actions A

// Déclaration d'un point de sauvegarde
MaConnexion.TransactionSavepoint("MonPointDeSauvegarde")

// Réalisation d'actions B

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

// Réalisation d'actions C

// Déclaration d'un point de sauvegarde
MaConnexion.TransactionSavepoint("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 TransactionPointDeSauvegarde() 
// et TransactionRetourneAuPointDeSauvegarde

MaConnexion.TransactionEnd()

// MonPointDeSauvegarde2 est désactivé

Syntax

<Result> = <Connection>.TransactionRollbackToSavepoint(<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>: 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 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