HDBOpenNoLock (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Using HDBOpenNoLock
Limitation

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HDBOpenNoLock (Function)

In french: HDBOuvreSansBloquer

Available 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("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.

Component: wd260hf.dll