HTransactionInProgress (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / Managing transactions / WLanguage functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HTransactionInProgress (Function)

In french: HTransactionEnCours

Used to find out whether a transaction is in progress.

The management of transactions is available for HFSQL Client/Server databases.

Example

// Tries to determine if a transaction is in progress
// ISAM database (HFSQL Classic)
bConnectionInProgress is boolean = HTransactionInProgress()

// Tries to determine if a transaction with MyConnection is in progress
// Client/Server database (HFSQL Client/Server)
MyConnection is Connection
bConnectionInProgress is boolean = HTransactionInProgress(MyConnection)

Syntax

<Result> = HTransactionInProgress([<Connection>])

<Result>: Boolean

If a connection is specified:
True if there is a transaction on the specified connection or if there is a global transaction (for HFSQL Classic (ISAM) and all HFSQL Client/Server connections).
False if there is no transaction in progress on the specified connection.
If no connection is specified:
True if there is a global transaction (for HFSQL Classic (ISAM) and all HFSQL Client/Server connections).
False otherwise. Caution: there may be transactions in progress on specific connections.

<Connection>: Optional character string or optional Connection variable

Connection to use. 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.

Business / UI classification: Business Logic

Component: wd270hf.dll