ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Locks set by HNoModif
  • Miscellaneous
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
HNoModif (Function)
In french: HInterditModif
ODBCNot available with this kind of connection
Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). The records can be accessed in read-only.
WEBDEV - Server code The restriction is performed for all the sessions and other programs (developed with WEBDEV), including the session that requested the restriction.
Example
HNoModif(Invoice)
// Process...
HEndNoModif(Invoice)
Syntax
<Result> = HNoModif(<Data file>)
<Result>: Boolean
  • True if no problem occurred,
  • False otherwise. HError returns more details about the problem.
If the data file is still locked after H.NbRetry attempts, HErrorLock returns True (the H.Locked variable is set to True).
If the data file was locked, HErrorLock returns False.
<Data file>: Character string
Name of the data file used.
Remarks

Locks set by HNoModif

HNoModif can lock in write mode a file already locked by another program (with HNoModif). Therefore, several programs can forbid the modifications on the same data file at the same time. A locking read function run after HNoModif in the same program reads the record without locking it.
HNoModif cannot lock a data file already locked in read/write by another program.
Reminder: the data file cannot be locked by HNoModif only if the data file is locked in read/write by another program.
Remarks:
  • In single-user mode (HMode), HNoModif is equivalent to HOpen (the data files are locked in read/write as soon as they are opened).
  • You have the ability to lock a data file whose records are locked by another application.

Miscellaneous

The maximum number of programs that can request the no-modification policy on a data file depends on the size of a record in the data file. It can be calculated as follows:
MaxNbSessionsOrPrograms = RecordSize - 20
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/03/2023

Send a report | Local help