HUnlockRecNum (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

HUnlockRecNum (Function)

In french: HDébloqueNumEnr

Not available with these kinds of connection

Unlocks a record locked by:

the HLockRecNum function,
a read function used with a locking parameter (for example, HRead used with the hLockWrite or hLockReadWrite constant).

Note The function HUnlockRecNum function does not unlock a Record blocked by another application.

This function is available for HFSQL data files only. It is not available for the data files accessed by JDBC.

Example

// Blocage
HLockRecNum(CLIENT, hRecNumCurrent, hLockReadWrite)
// Modification de l'enregistrement
...
// Déblocage
HUnlockRecNum(CLIENT, hRecNumCurrent)

Syntax

<Result> = HUnlockRecNum([<Data file> [, <Record number>]])

<Result>: Boolean

True if the record was unlocked,
False if a problem occurs. HError is used to identify the error.

<Data file>: Optional character string

Name of the data file used.
If this name is not specified, HUnlockRecNum will use the last data file used by the last HFSQL function (function starting with "H").

<Record number>: Optional integer

Number of the record to unlock.
If this number is not specified (or is equal to 0 or to the hCurrentRecNum constant), HUnlockRecNum will read the current record.
HUnlockRecNum unlocks the current record only. You cannot specify a record number other than the current one (to specify the current record number, use the hRecNumCurrent constant).

Remarks

HUnlockRecNum has no effect if:

The data file is in single-user mode (see HMode).
The record is not locked.

Component: wd300hf.dll