HInfoFile (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HInfoFile (Function)

In french: HInfoFichier

Available only with these kinds of connection

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:
hFicSize Data file (".Fic") size in bytes.
hFtxSize Full-text index file (".Ftx") size in bytes.
hMmoSize Memo file (".Mmo") size in bytes.
hNdxSize Index file (".Ndx") size in bytes.
hSdxSize Spatial index file (".Sdx") size in bytes.
hTotalSize Total 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:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

<Data file>: Character string

Physical name of the data file to analyze.

<Information>: Integer constant

Requested information about the data file:
hFicSize Data file (".Fic") size in bytes.
hFtxSize Full-text index file (".Ftx") size in bytes.
hMmoSize Memo file (".Mmo") size in bytes.
hNdxSize Index file (".Ndx") size in bytes.
hSdxSize Spatial index file (".Sdx") size in bytes.
hTotalSize Total data file size in bytes (cumulative size of data file, memo file and index file).

Component: wd300hf.dll