HSetTransaction (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Managing databases

Managing transactions

WLanguage functions

Prefix syntax

HSetTransaction

Presentation

Example

Management of transactions enabled

Limit

See also

HSetTransaction (Function)

In french: HGèreTransaction

Available only with these kinds of connection

Enables or disables the management of transactions for one or more data files.

When the management of transactions is disabled, all transaction-related functions are inhibited (HTransactionStart, HTransactionEnd, HTransactionCancel).

Remark: The management of transactions is enabled by default.

This function can be used with HFSQL Client/Server data files only.

Example

// Disable the management of transactions on the Customer data file
HSetTransaction(Customer, False)

Syntax

<Result> = HSetTransaction([<Data file>, ] <Options>)

<Result>: Boolean

Corresponds to the former management mode of transactions (before the call to HSetTransaction):
True if the management of transactions was enabled,
False if the management of transactions was disabled.
If <Data file>= "*", <Result> is set to True if the management of transactions was enabled for at least one data file in the former transaction management mode.

<Data file>: Optional character string

Name of the data file used. If this name is not specified or if it corresponds to "*", the management of transactions is taken into account for all the date files found in the analysis.

<Options>: Boolean

True if the management of transactions must be enabled for the data file,
False if this management must be disabled.

Remarks

Management of transactions enabled

If the management of transactions is enabled for a single file, only the operations performed on this data file will be taken into account in the management of transactions (regardless of the data files specified in HTransactionStart).

Limit

The management of transactions does not apply to the xBase files.

Component: wd270hf.dll