HTransactionIsolation (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

WLanguage

Management of databases

Management of transactions

WLanguage functions

HTransactionIsolation

Presentation

Example

See also

HTransactionIsolation (Function)

In french: HTransactionIsolation

Available only with this kind of connection

Configures the isolation mode of transactions for a connection to a HFSQL server.

Depending on the mode selected, an application that performs reading operations will have access or not to the data being modified in a transaction by another application, or another instance of the same application.

See Client/Server transactions: Available isolation modes for more details.

Example

HTransactionIsolation(cnt, hReadCommitted)
HReadFirst(MyCustomerFile, MyKey)

Syntax

<Result> = HTransactionIsolation(<Connection name> , <Isolation mode>)

<Result>: Boolean

True if the isolation level was implemented,
False if an error occurred. HErrorInfo is used to identify the error.

<Connection name>: Character string (with or without quotes)

Name of connection to a HFSQL server. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.

<Isolation mode>: Integer constant

Selected isolation mode:
hReadCommitted Only the finalized transactions are visible by the other users.
hReadUncommitted The non-finalized transactions are visible by the other users.
hRepeatableRead The application in transaction sees a snapshot of the database when the transaction starts.

Component : wd240hf.dll