ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
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
Used to check whether a lock error occurred. This function must be used for custom management of locks and modification conflicts.
Remark: An automatic management of lock errors and modification conflicts is performed by default (except in the code of stored procedures). This assisted management of errors can be customized or disabled at any time by HOnError.
Example
// Read the first record
HReadFirst(Customer, Name)
// Lock error?
IF HErrorLock() = True THEN
Error("A lock error was detected")
END
Syntax
<Result> = HErrorLock()
<Result>: Boolean
  • True if a lock error occurred,
  • False otherwise (no error).
Remarks
  • No automatic management of locks is available for the Memo or Binary Memo items.
  • Once a locked record was read, no read operation is performed on the data file:
    • HErrorLock returns True.
    • HOut returns True.
      Therefore, if the read operation is performed while looping through an HFSQL data file, the iteration is interrupted.
      The H.NbRetry variable indicates the number of attempts to lock the data file or record before giving control back to the program (only in multi-user mode).
  • This function replaces HIsLocked, which is kept for compatibility with WINDEV 5.5.
Business / UI classification: Business Logic
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/07/2023

Send a report | Local help