ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
RepeatableReadSupported (Property)
In french: RepeatableReadSupporté
HFSQL Client/ServerAvailable only with this kind of connection
The RepeatableReadSupported property is used to:
  • Determine if the data file (defined in the data model editor or programmatically) can be used in HFSQL Client/Server in a transaction that includes a "REPEATABLE READ" isolation level.
  • Allow the use of a transaction that includes a "REPEATABLE READ" isolation level for a data file (files described programmatically only).
Caution: if this option is enabled, the file is not compatible with versions 18 and earlier.
This property corresponds to the "Allow REPEATABLE READ transactions" option in the "Options" tab of the file description window in the analysis.
Example
IF Customer.RepeatableReadSupported = False THEN Info("Unable to use the Repeatable Read mode")
Syntax

Determining if the file can be used in "REPEATABLE READ" mode Hide the details

<Result> = <Data file>.RepeatableReadSupported
<Result>: Boolean
  • True if the file can be used in "REPEATABLE READ" mode,
  • False otherwise.
<Data file>: File name
Name of the data file used. This name is defined in the data model editor or with the File Description type.

Defining whether the file can be used in "REPEATABLE READ" mode Hide the details

<Data file>.RepeatableReadSupported = <"REPEATABLE READ" Mode>
<Data file>: File name
Name of the data file used. This name is defined with the File Description type.
<"REPEATABLE READ" Mode>: Boolean
  • True if the file can be used in "REPEATABLE READ" mode,
  • False otherwise.
Minimum version required
  • Version 19
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/29/2024

Send a report | Local help