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
Used to find out if a data file exists, i.e. if it has been physically created (<Source>.Creation or <Source>.CreationIfNotFound).
Remark: The substitutions currently performed on the data file (by HSubstDir, <Source>.ChangeDir and <Source>.ChangeName) are taken into account.
Example
// Describe the connection
MyConnection is Connection
 
// Check whether a Client/Server data file exists
IF MyConnection.FileExist("MyFile.FIC") = True THEN
// Processes
...
END

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

<Result> = <Connection>.FileExist(<Physical file>)
<Result>: Boolean
  • True if the physical data file exists on the server,
  • False otherwise.
<Connection>: Connection variable
Name of the Connection variable that describes the connection associated with the data file.
<Physical file>: Character string
Physical name of the searched data file. The file extension must be specified ("Customer.fic" for example).
Remarks
  • <Connection variable>.FileExist can be used whether the file is open or closed.
  • <Connection variable>.FileExist does not open the data file if it is closed.
Component: wd290hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help