HInfoFile (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

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.

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

New in version 22

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

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 (with or without quotes)

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).
Versions 14 and later
hFtxSize
New in version 14
hFtxSize
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 (with or without quotes) 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 Connection variable.

<Data file>: Character string (with quotes)

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).
Versions 14 and later
hFtxSize
New in version 14
hFtxSize
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: wd260hf.dll