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
Unlocks a record locked by:
  • the <Source>.LockRecNum function,
  • a read function used with a locking parameter (for example, <Source>.Read used with the hLockWrite or hLockReadWrite constant).
Remark: <Source>.UnlockRecNum 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.
Example
// Lock
Customer.LockRecNum(hRecNumCurrent, hLockReadWrite)
// Modify the record
...
// Unlock
Customer.UnlockRecNum(hRecNumCurrent)
Syntax
<Result> = <Source>.UnlockRecNum([<Record number>])
<Result>: Boolean
  • True if the record was unlocked,
  • False if a problem occurs. HError is used to identify the error.
<Source>: Type corresponding to the specified source
Name of the data file used.
<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), <Source>.UnlockRecNum will read the current record.
Native Connectors (Native Accesses) <Source>.UnlockRecNum 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
<Source>.UnlockRecNum has no effect if:
  • The data file is in single-user mode (see <Source>.Mode).
  • The record is not locked.
Component: wd290hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help