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
  • Link between xBase files
  • Limitations
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HDBOpen (Function)
In french: HDBOuvre
Native Connectors (Native Accesses)HFSQL ClassicAvailable only with these kinds of connection
Opens the xBase data file and the "memo" file, if any.
Example
HDBOpen("COMMANDE", "CO", "C:\FICHIER\COMMANDE.DBF")
HDBIndex("COMMANDE", "C:\FICHIER\COMMANDE.NTX", "NumCde")
HDBOpen("PRODUIT", "PR", "C:\FICHIER\PRODUIT.DBF")
HDBIndex("PRODUIT", "C:\FICHIER\PRODUIT.NTX", "NumProd")

// Affichage des caractéristiques de la commande 
HReadFirst("COMMANDE", "NumCde")
IF HOut() = False THEN
	HReadSeek("PRODUIT", "NumProd", CO.NUMPROD)
	FileToScreen()
ELSE
	Error("Fichier vide")
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 occurs. 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 programmatically.
<Abbreviation of xBase file>: Character string
Prefix (2 characters) used through programming to identify a file item. For example, if the prefix of the "Customer" data file is CL, to use the "Name" field in this file, use the syntax CL.NAME.
Warning: several data files opened with HDBOpen 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

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:
// Lecture du fichier xBase
IF HOut() = False THEN
	HReadSeek(NomFichier, NomClé, Valeur_Clé)
END

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: 03/27/2025

Send a report | Local help