HErrorLock (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HErrorLock (Function)

In french: HErreurBlocage

Not available with this kind of connection

Used to check whether a lock error occurred. This function must be used for custom management of locks and modification conflicts.

Note: By default, a automatic management of lock errors and modification conflicts is performed (except in stored procedure code).. This assisted management of errors can be customized or disabled at any time by HOnError.

Example

// Lecture du premier enregistrement
HReadFirst(Client, Nom)
// Erreur de blocage?
IF HErrorLock() = True THEN
	Error("Une erreur de blocage a été détectée")
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: wd300hf.dll