HTransactionSavepoint (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HTransactionSavepoint (Function)

In french: HTransactionPointDeSauvegarde

Declares a transaction savepoint. This allows you to roll the transaction back to this savepoint later (HTransactionRollbackToSavepoint).

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> = 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:
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

Savepoint name.
Remark: The name of the savepoint cannot start with "#".

Remarks

This function must be used in a transaction.
The corresponding SQL statement can also be used: "SAVEPOINT identifier".
This function is not available:
- on HFSQL files in cluster mode,
- with files handled via a Native Connector.

Business / UI classification: Business Logic

Component: wd300hf.dll