ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Declares a transaction savepoint. This allows you to roll the transaction back to this savepoint later (HTransactionRollbackToSavepoint).
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> = HTransactionSavepoint([<Connection>, ] <Savepoint name>)
<Result>: Boolean
  • True if the savepoint has been created,
  • 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: If this parameter is not specified, the current connection is used.
<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
Minimum version required
  • Version 27
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/12/2025

Send a report | Local help