PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • Using HDBOpenNoLock
  • Limitation
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
HDBOpenNoLock (Function)
In french: HDBOuvreSansBloquer
Native Connectors (Native Accesses)HFSQLAvailable only with these kinds of connection
In single-user mode, opens an xBase data file without locking it. The opened file can be shared between several programs.
In multi-user mode, operating mode equivalent to the one of HDBOpen.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
HMode("*", hModeMono)
HDBOpenNoLock("COMMANDE", "CO", "C:\FICHIER\COMMANDE.DBF")
HDBIndex("COMMANDE", "C:\FICHIER\COMMANDE.NTX", "NumCde")
HReadFirst("COMMANDE", "NumCde")
WHILE HOut() = False
Afficher_commande
HReadNext()
END
Syntax
<Result> = HDBOpenNoLock(<Logical name of xBase file> , <Abbreviation of xBase file> , <Full name of xBase file>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError is used to identify the error.
<Logical name of xBase file>: Character string
Logical name given to the xBase file. This name will be used to handle the xBase file by programming.
<Abbreviation of xBase file>: Character string
Prefix (2 characters) used through programming to identify a file item. For example, the prefix of "Customer" file being CU, the syntax for using the "Name" item of this file is CU.NAME.
Caution: several files opened by HDBOpenNoLock cannot have the same abbreviation, even if the files have been closed.
<Full name of xBase file>: Character string
Path and full name of xBase file to open (with the extension).
Remarks

Using HDBOpenNoLock

Caution: HDBOpenNoLock must only be used in the programs that do not modify the file and that use the single-user mode. Indeed, the opened file is not locked. Thus, the following functions should not follow HDBOpenNoLock:

Limitation

  • This function is not available when using a database via Remote Access.
  • This function is not available when using a stand-alone executable.
Component: wd270hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment