Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
HUnlockRecNum (Function)
In french: HDébloqueNumEnr
ODBCOLE DBNot 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.
Java This function is available for HFSQL data files only. It is not available for the data files accessed by JDBC.
// Lock
HLockRecNum(CUSTOMER, hRecNumCurrent, hLockReadWrite)
// Modify the record
// Unlock
HUnlockRecNum(CUSTOMER, hRecNumCurrent)
<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.
Native Connectors (Native Accesses) 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).
HUnlockRecNum has no effect if:
  • The data file is in single-user mode (see HMode).
  • The record is not locked.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help