HTransactionList (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Managing databases

Managing transactions

WLanguage functions

Prefix syntax

HTransactionList

Presentation

Example

See also

HTransactionList (Function)

In french: HTransactionListe

Available only with this kind of connection

Returns the list of current or interrupted transactions on the server for the specified connection.

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

Example

MyConnection is Connection

// Retrieve the list of transactions
sListTrs is string = HTransactionList(MyConnection)

Syntax

<Result> = HTransactionList(<Connection>)

<Result>: Character string

List of current or interrupted transactions found on the server associated with the connection. This list has the following format:

<Transaction identifier> + TAB + <Application name> + TAB +
<Client computer > + TAB + <Value of HComputer> + TAB +
<Transaction status> + CR +...

<Transaction status> is set to 0 for a current transaction and to 1 for an interrupted transaction.

<Connection>: Character string or Connection variable

Connection for which the transactions must be listed. 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.

Component: wd280hf.dll