PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
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
Used to find out:
Versions 17 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App 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
Android Widget This function is now available in Android widget mode.
Java This function is now available for Java applications.
Android This function is now available for Android applications.
New in version 22
Android Widget This function is now available in Android widget mode.
Java This function is now available for Java applications.
Android This function is now available for Android applications.
Android Widget This function is now available in Android widget mode.
Java This function is now available for Java applications.
Android This function is now available for Android applications.
Example
// 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").
WINDEVWEBDEV - Server codeReports and QueriesUniversal Windows 10 AppAndroidAndroid Widget iPhone/iPadJavaUser code (UMC)AjaxHFSQL 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: wd270hf.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment