ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Attention : This is version 26 of this documentation page. This feature may have been changed or removed in a higher version.
Help / WLanguage / Managing databases / HFSQL functions / Compatible Hyper File functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HStartLock (Function)
In french: HDébutVerrou
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Warning
This function is available for backward compatibility (this function will still be available in the forthcoming version).
Caution: Modification since WINDEV 5.5: HAdd, HCross, HModify, HWrite, ... unlock the record.
The documentation about HStartLock available in WINDEV 5.5 is as follows.
Windows Mobile This function can be used with HFSQL Client/Server data files or with data files handled by Native Accesses. This function is not available for HFSQL Mobile.
 
Purpose
Marking the start of read lock on data files.
Syntax
HStartLock
Details
The records read after HStartLock will be locked.
HRead, HReadSeek, HReadFirst, HReadLast, HReadNext and HReadPrevious read and lock the record (they are equivalent to HReadLock, HReadSeekLock...).
HAdd, HCross, HModify, HWrite... do not unlock the record.
The records will be unlocked during HEndLock.
Notes
  • The end of lock is declared by HEndLock.
  • After HStartLock, to read a record without locking it, you must use HReadNoLock, HReadFirstNoLock, HReadLastNoLock, HReadPreviousNoLock, HReadNextNoLock or HReadSeekNoLock.
  • Locking the data files is useful in semi-custom mode. Indeed, in automatic mode, the data files are locked as soon as they are opened.
  • For each data file, the maximum number of records that can be locked is equal to 16.000. Therefore, you must control the total number of locked records. Above 16.000 locked records, the entire data file must be locked (HLockFile or HLockEntireFile).
  • HStartLock and HEndLock are used to easily transform a single-user program into a program that supports locks.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/26/2021

Send a report | Local help