HTransactionRollbackToSavepoint (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Managing databases

Managing HFSQL Client/Server

HTransactionRollbackToSavepoint

Presentation

Example

See also

TransactionRollbackToSavepoint

TransactionSavepoint

Authentication via Active Directory

Client/Server: Connecting the client computers to the server

Compressing frames (DSL, 3G, Edge, VPN, ...)

Converting an HFSQL Classic database into HFSQL Client/Server

Differences and specific features of an HFSQL Client/Server application

Docker image of the HFSQL server

Functions for HFSQL Client/Server management (prefix syntax)

HCheckServerUpdate

HClient structure

HFConf.Ini file

HFSQL Client/Server database: Recommendations

HFSQL Client/Server management functions

HFSQL Client/Server: Configuring the data files on the server

HFSQL Client/Server: Configuring the server

HFSQL Client/Server: Managing the ports

HFSQL Client/Server: Overview

HFSQL Client/Server: Principle for saving the databases

HFSQL Client/Server: Scheduled tasks

HFSQL and Docker

HManageServerUpdate

HTransactionRollbackToSavepoint

HTransactionSavepoint

How to backup HFSQL Client/Server databases?

Keep-alive on connection

Managing rights on HFSQL Client/Server

Managing the groups and users (HFSQL Client/Server)

Managing the load balancing (dynamic load balancing on server)

Materialized view

Notifications of an HFSQL server

Operating mode of HFSQL application

Optimizing the connection times to the HFSQL Client/Server databases

Optional connection information

Restoring an HFSQL Client/Server database

SQL view

Spare server

Stored procedures and queries (HFSQL Client/Server)

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HTransactionRollbackToSavepoint (Function)

In french: HTransactionRetourneAuPointDeSauvegarde

Rolls the transaction back to the savepoint.

Example

MyConnection is Connection

// Start transactions
HTransactionStart(MyConnection)

// Actions A

// Declare a savepoint
HTransactionSavepoint(MyConnection, "MySavepoint")

// Actions B

// Undo all actions after the declaration of MySavepoint
HTransactionRollbackToSavepoint(MyConnection, "MySavepoint")

// Actions C

// Declare a savepoint
HTransactionSavepoint(MyConnection, "MySavepoint2")

// Actions D

// Validate (commit) transactions
// Actions A, C and D are taken into account,
// but not B actions because they are between HTransactionSavepoint()
// and HTransactionRollbackToSavepoint

HTransactionEnd(MyConnection)

// MySavepoint2 is disabled

Syntax

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

<Result>: Boolean

True if rolled back successfully,
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 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: wd280hf.dll