<Connection variable>.TransactionIsolation (Function)

Help

WLanguage

Managing databases

HFSQL functions

HFSQL Client/Server functions

ActivateServerTrigger

AddGroup

AddLink

AddScheduledBackup

AddScheduledOptimization

DeactivateServerTrigger

DeleteScheduledBackup

DeleteScheduledOptimization

DescribeServerTrigger

ExecuteScheduledBackup

ListScheduledOptimization

ModifyDatabaseProperty

ModifyScheduledBackup

ModifyScheduledOptimization

NotifAddEmailRecipient

NotifConfigure

NotifDeleteCCRecipient

NotifDeleteEmailRecipient

NotifListCCRecipient

NotifListEmailRecipient

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.TransactionIsolation (Function)

In french: <Variable Connexion>.TransactionIsolation

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

MyConnexion.TransactionIsolation(hReadCommitted)
MyCustomerFile.ReadFirst(MyKey)

Syntax

<Result> = <Connection>.TransactionIsolation(<Isolation mode>)

<Result>: Boolean

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

<Connection>: Connection variable

Name of the Connection variable that describes the connection to an HFSQL server.

<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