Home | Sign in | English EN

  • Locks set by HNoModif
  • Various
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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.
Windows Mobile This function can be used with HFSQL Client/Server data files or with data files handled by Native Connectors. This function is not available for HFSQL Mobile.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
// Process...
<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 (with or without quotes)
Name of data file used.

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


  • 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
  • This function is not available when accessing a database via Remote Access.
Component: wd260hf.dll
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment