HInfoFile (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

// Get the size of a data file
// by using the current connection of a data file
Trace("Total size of Customer file: " + HInfoFile(Customer, hTotalSize))

// Get the size of a data file by using a connection 

// Connection parameters
CntTest is Connection
CntTest.Provider = hAccessHFClientServer
CntTest.User = "admin"
CntTest.Password = "pass_admin"
CntTest.Server = "server:4930"
CntTest.Database = "TestDatabase"

Trace("Total size of Customer file: " + ...
	HInfoFile(CntTest.Name, "FileName.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.
New in version 2024
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.
New in version 2024
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: wd290hf.dll