HTransactionIsolation (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HTransactionIsolation (Function)

In french: HTransactionIsolation

Available only with this kind of connection

Configures the isolation mode of transactions for a connection to an 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

MyConnection is Connection
HTransactionIsolation(MyConnection, hReadCommitted)
HReadFirst(MyCustomerFile, MyKey)

Syntax

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

<Result>: Boolean

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

<Connection>: Character string (with or without quotes) 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 Connection variable.

<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 : wd250hf.dll