<Connection variable>.InfoFile (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

<Connection variable>.InfoFile (Function)

In french: <Variable Connexion>.InfoFichier

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 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 : " + ...
	CnxTest.InfoFile("NomFichier.FIC", hTotalSize))

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

<Result> = <Connection>.FileInfo(<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>: Connection variable

Name of the Connection variable that describes the connection to use.

<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