ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / Managing xBase files / WLanguage functions
  • Name of the key
  • Limitations
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HDBIndex (Function)
In french: HDBIndex
Native Connectors (Native Accesses)HFSQL ClassicAvailable only with these kinds of connection
Opens an xBase index file. The index file(s) of an xBase data file opened with HDBOpen must be opened with HDBIndex to be used in WINDEV or WEBDEV. If the index files are not opened, they will not be updated when the file is written to.
Note: if the file has just been created with function HDBCreation, it is not necessary to open the data file or index files.
Example
HDBOpen("CUSTOMER", "CU", "C:\FILE\CUSTOMER.DBF")
HDBIndex("CUSTOMER", "C:\FILE\CUSTNAME.NTX", "CustName")
HDBIndex("CUSTOMER", "C:\FILE\CUSTPHONE.NTX", "Phone")
Syntax
<Result> = HDBIndex(<Logical name of xBase file> , <Full name of index file> , <Key name>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurs. HError is used to identify the error.
<Logical name of xBase file>: Character string
Name given to the xBase file. This file was opened by HDBOpen.
<Full name of index file>: Character string
Access path to index file and full file name (with the extension)
<Key name>: Character string
Name of index key. This parameter is mandatory for the files in .NDX, .NTX and .IDX format (indeed, the name of the key does not appear in the file). It is useless and ignored for files in .MDX format (because the key name appears in the file).
Remarks

Name of the key

If the key is a calculated key (multiple), you must not specify all the items included the key, but any name that will be used in programming. For clarity, the name of the corresponding index file is often used.

Limitations

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

Last update: 12/06/2024

Send a report | Local help