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

Finding out information regarding an HFSQL Classic data file Hide the details

<Result> = HInfoFile(<Data file> , <Information>)

<Result>: Type of the requested information

Sought information.

<Data file>: Character string

Name of the data file to analyze.

<Information>: Integer constant

Requested information about the data file:
hFicSize Size of data file in bytes (".Fic" file).
hFtxSize Size of full-text index file in bytes (".Ftx" file).
hMmoSize Size of memo file in bytes (".Mmo" file).
hNdxSize Size of index file in bytes (".Ndx" file).
hTotalSize Total data file size in bytes (cumulative size of data file, memo file and index file).

Finding out information regarding an HFSQL Client/Server data file Hide the details

<Result> = HInfoFile(<Connection> , <Data file> , <Information>)

<Result>: Type of the requested information

Requested information,
0 if the connection exists but the data file is not found on the drive.

<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 Size of data file in bytes (".Fic" file).
hFtxSize Size of full-text index file in bytes (".Ftx" file).
hMmoSize Size of memo file in bytes (".Mmo" file).
hNdxSize Size of index file in bytes (".Ndx" file).
hTotalSize Total data file size in bytes (cumulative size of data file, memo file and index file).

Component: wd280hf.dll