HFileExist (Function)

whether a data file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
Note: 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 the iPhone/iPad applications.

New in version 17

This function is now available for the 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.

Note: 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 the Java applications.

This function is now available for the Android applications.

New in version 22

This function is now available in Android Widget mode.

This function is now available for the Java applications.

This function is now available for the Android applications.

This function is now available in Android Widget mode.

This function is now available for the Java applications.

This function is now available for the Android applications.

Example

See additional examples

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

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

Syntax

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

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

<Result>: Boolean

True if the physical file exists,
False otherwise.

<Element Name>: 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 handles the last data file, query or view used by the last function for HFSQL management (starting with the letter H).

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

<Result> = HFileExist(<Connection Name> , <File Name>)

<Result>: Boolean

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

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

Name of connection associated with the data file. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.

<File Name>: Character string (with quotes)

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

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

<Result> = HFileExist(<Connection Name> , <File Name>)

<Result>: Boolean

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

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

Name of connection associated with the data file. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.

<File Name>: 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 this one is closed.

Component : wd240hf.dll