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:
Note: From version 19, HFSQL is the new name of HyperFileSQL.
// 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).
Reports and QueriesHFSQL Client/Server

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).
Reports and QueriesHFSQL Client/Server

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
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment