PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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 the 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 the 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 the Java applications.
Android This function is now available for Android applications.
// 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").
WINDEVWEBDEV - Server codeReports and QueriesAndroidAndroid Widget iPhone/iPadUniversal Windows 10 AppWindows MobileJavaAjaxUser code (UMC)HFSQL 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 (with or without quotes) or Connection variable
Connection associated with the data file. This connection corresponds to:
<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 : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment