HFileExist (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

HFileExist (Function)

In french: HFichierExiste

Used to find out:

if a data file exists, i.e. if it has been physically created (HCreation or HCreationIfNotFound).
Remark: The substitutions currently performed on the data file (by HSubstDir, HChangeDir and HChangeName) are taken into account.
whether a view or a query was defined.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

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 in Android Widget mode.

This function is now available for Java applications.

This function is now available for Android applications.

New in version 22

This function is now available in Android Widget mode.

This function is now available for Java applications.

This function is now available for Android applications.

This function is now available in Android Widget mode.

This function is now available for Java applications.

This function is now available for Android applications.

Example

See additional examples

// Check whether the "Customer" data file exists
IF HFileExist(Customer) = True THEN
// Processes
...
END

// Check whether a Client/Server data file exists
IF HFileExist(MyConnection, "MyFile.FIC") = True THEN
// Processes
...
END

Syntax

Checking the existence of a data file, query or view Hide the details

<Result> = HFileExist([<Element>])

<Result>: Boolean

True if the physical file exists,
False otherwise.

<Element>: Optional character string (with or without quotes)

Name of element to use:
Name of data file.
Name of view or query.
If this name is not specified, HFileExist will use the last data file, query or view used by the last HFSQL management function (function starting with "H").

Checking the existence of a data file in HFSQL Client/Server Hide the details

<Result> = HFileExist(<Connection> , <Physical file>)

<Result>: Boolean

True if the physical data file exists on the server,
False otherwise.

<Connection>: Character string (with or without quotes) or Connection variable

Connection associated with the data file. 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.

<Physical file>: Character string (with quotes)

Physical name of sought data file. The file extension must be specified ("Customer.fic" for example).

Remarks

HFileExist can be used no matter whether the data file is opened or not.
HFileExist does not open the data file if it is closed.

Component: wd260hf.dll