HTransactionIsolation (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Managing databases

Managing transactions

WLanguage functions

Prefix syntax

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 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.

For more details, see Client/Server transactions: Available isolation modes.

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 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 variable of type Connection.

<Isolation mode>: Integer constant

Selected isolation mode:
hReadCommitted Other users can only view completed transactions.
hReadUncommitted Other users can view incomplete transactions.
hRepeatableRead The application in transaction sees a snapshot of the database when the transaction starts.

Component: wd280hf.dll