HDBOpen (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Link between xBase files

Limitations

See also

HDBOpen (Function)

In french: HDBOuvre

Available only with these kinds of connection

Opens the xBase data file and the "memo" file if it exists.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

HDBOpen("ORDERS", "OR", "C:\FILE\ORDERS.DBF")
HDBIndex("ORDERS", "C:\FILE\ORDERS.NTX", "OrdNum")
HDBOpen("PRODUCT", "PR", "C:\FILE\PRODUCT.DBF")
HDBIndex("PRODUCT", "C:\FILE\PRODUCT.NTX", "ProdNum")

// Display the characteristics of the order
HReadFirst("ORDERS", "OrdNum")
IF HOut() = False THEN
        HReadSeek("PRODUCT", "ProdNum", CO.PRODNUM)
        FileToScreen()
ELSE
        Error("Empty file")
END

Syntax

<Result> = HDBOpen(<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, if the prefix of "Customer" file is CU, the syntax for using the "Name" item of this file is CU.NAME.
Caution: Several data files opened by HDBOpen 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

Link between xBase files

The links between xBase files are not automatically managed. Therefore, you must write the "link" code to access a record in a linked file. The record in the linked file must be read whenever the file is read:

// Read the file
IF HOut() = False THEN
HReadSeek(FileName, KeyName, Key_Value)
END

Limitations

This function is not available when accessing a database via Remote Access.
This function is not available when using a stand-alone executable.

Component : wd250hf.dll