ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Returns the characteristics of an HFSQL Classic or Client/Server data file.
Example
// Récupération de la taille d'un fichier de données
// en utilisant la connexion en cours d'un fichier de données
Trace("Taille totale fichier de données Client : " + HInfoFile(Client, hTotalSize))
// Récupération de la taille d'un fichier de données en utilisant une connexion 
// Paramètres de la connexion
CnxTest is Connection
CnxTest.Provider = hAccessHFClientServer
CnxTest.User = "admin"
CnxTest.MotDePasse = "pass_admin"
CnxTest.Server = "serveur:4930"
CnxTest.Database = "BaseTest"
Trace("Taille totale fichier de données Client : " + ...
	HInfoFile(CnxTest.Name, "NomFichier.FIC", hTotalSize))
Syntax

Getting the details of an HFSQL Classic data file Hide the details

<Result> = HInfoFile(<Data file> , <Information>)
<Result>: Type of the desired information
Desired information.
<Data file>: Character string
Name of the data file to analyze.
<Information>: Integer constant
Requested information about the data file:
hFicSizeData file (".Fic") size in bytes.
hFtxSizeFull-text index file (".Ftx") size in bytes.
hMmoSizeMemo file (".Mmo") size in bytes.
hNdxSizeIndex file (".Ndx") size in bytes.
hSdxSizeSpatial index file (".Sdx") size in bytes.
hTotalSizeTotal data file size in bytes (cumulative size of data file, memo file and index file).

Getting the details of an HFSQL Client/Server data file Hide the details

<Result> = HInfoFile(<Connection> , <Data file> , <Information>)
<Result>: Type of the desired information
  • Requested information,
  • 0 if the connection exists but the data file does not exist on the disk.
<Connection>: Character string or Connection variable
Connection to use. This connection corresponds to:
<Data file>: Character string
Physical name of the data file to analyze.
<Information>: Integer constant
Requested information about the data file:
hFicSizeData file (".Fic") size in bytes.
hFtxSizeFull-text index file (".Ftx") size in bytes.
hMmoSizeMemo file (".Mmo") size in bytes.
hNdxSizeIndex file (".Ndx") size in bytes.
hSdxSizeSpatial index file (".Sdx") size in bytes.
hTotalSizeTotal data file size in bytes (cumulative size of data file, memo file and index file).
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