ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Determines:
// 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
Name of the element to be used:
  • 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").
Universal Windows 10 AppAndroidAndroid Widget iPhone/iPadHFSQL Client/Server

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 or Connection variable
Connection associated with the data file. This connection corresponds to:
<Physical file>: Character string
Physical name of the searched data file. The file extension must be specified ("Customer.fic" for example).
Remarks
  • HFileExist can be used whether the file is open or closed.
  • HFileExist does not open the data file if it is closed.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help