HUnlockRecNum (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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).

Remark: HUnlockRecNum does not unblock a record locked by another application.

Example

// Lock
HLockRecNum(CUSTOMER, hRecNumCurrent, hLockReadWrite)
// Modify the record
...
// Unlock
HUnlockRecNum(CUSTOMER, 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