PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | French EN

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
RepeatableReadSupported (Property)
In french: RepeatableReadSupporté
HFSQL Client/ServerAvailable only with this kind of connection
..RepeatableReadSupported is used to:
  • Find out whether the data file (file defined in the data model editor or by programming) can be used in HFSQL Client/Server in a transaction that includes a "Repeatable Read" isolation mode.
  • Allow the use of a transaction that includes a "Repeatable Read" isolation mode for a data file (when the file is described by programming only).
Caution: if this option is enabled, the file is not compatible with versions 18 and earlier.
This property corresponds to the option "Allow the REPEATABLE READ transactions (requires HFSQL version 19 or later)", in the "Details" tab of the file description window in the analysis.
Example
IF Customer..RepeatableReadSupported = False THEN Info("Unable to use the Repeatable Read mode")
Syntax

Finding out whether 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>: Character string (with or without quotes)
Name of data file used. This name was defined in the data model editor or by 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>: Character string (with or without quotes)
Name of data file used. This name was defined by 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