PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Using HDBOpenNoLock
  • Limitation
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
HDBOpenNoLock (Function)
In French: HDBOuvreSansBloquer
Native AccessesHFSQLAvailable 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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
HMode("*", hModeMono)
HDBOpenNoLock("ORDERS", "OR", "C:\FILE\ORDERS.DBF")
HDBIndex("ORDERS", "C:\FILE\ORDERS.NTX", "OrdNum")
HReadFirst("ORDERS", "OrdNum")
WHILE HOut() = False
        Display_order
        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 (with quotes)
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 (with quotes)
Prefix (2 characters) used by 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 (with quotes)
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. Therefore, the following functions must not be used after HDBOpenNoLock:

Limitation

  • This function is not available when accessing a database via Remote Access.
  • This function is not available when using a stand-alone executable.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment