<Connection variable>.TransactionSavepoint (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>.TransactionSavepoint (Function)

In french: <Variable Connexion>.TransactionPointDeSauvegarde

Declares a transaction savepoint. This allows you to roll the transaction back to this savepoint later (<Connection variable>.TransactionRollbackToSavepoint).

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>.TransactionSavepoint(<Savepoint name>)

<Result>: Boolean

True if the savepoint has been created,
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

Savepoint name.
Note: The save point name cannot begin with "#".

Remarks

This function must be used in a transaction.
The corresponding SQL command is also available: "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