HTransactionIsolation (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

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.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Versions 22 and later

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

New in version 22

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

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