PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Deleting a data file
  • Names of files and directories on the LINUX server
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
HDeleteFile (Function)
In French: HSupprimeFichier
HFSQL Client/ServerAvailable only with this kind of connection
Deletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if they exist) from the server.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the 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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 19 and later
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
WINDEVJava This function is now available for the Java applications.
New in version 19
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
WINDEVJava This function is now available for the Java applications.
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
WINDEVJava This function is now available for the Java applications.
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.
Example
// Deletes the files from the server
HDeleteFile(MyConnection, ".\backup\customerfile_bck.fic")
WINDEVWEBDEV - Server codeWindows MobileHFSQL Client/Server
IF HDeleteFile(Ct_test, ".\Customer.FIC") = False THEN
Error(HErrorInfo())
END
Syntax
<Result> = HDeleteFile(<Connection Name> , <Physical File Path> [, <Options>])
<Result>: Boolean
  • True if the data file was deleted,
  • False if an error occurred (the data file does not exist on the server for example). HError is used to identify the error.
<Connection Name>: Character string (with or without quotes)
Name of the connection in which the data file must be deleted. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
<Physical File Path>: Character string (with quotes)
Name and path of the data file to delete. The path is relative to the database: the name of the database must not be specified in the path. The ".fic" extension of the data file must be specified.
<Options>: Optional Integer constant (or combination of constants)
By default, when deleting a data file:
  • the files corresponding to the logs are not deleted,
  • the files corresponding to the transactions are deleted.
This parameter is used to modify this behavior:
hKeepTRSKeeps the transaction file associated with the deleted data file.
hDestroyLinkDeletes all the links related to the deleted data file.
hDeleteLogDeletes the Log file and all the logged operations associated with the deleted data file.
Remarks

Deleting a data file

The data file can be deleted only if it is not currently used (which means if it is not used by a query, a view, another window, a thread or a component with independent HFSQL context).
The data file is automatically closed in the HFSQL context that calls HDeleteFile. A WLanguage error occurs if the data file is used in a context or by an application.

Names of files and directories on the LINUX server

On a LINUX server, the name of data files (.fic, .ftx, .ndx and .mmo files if they exist) must be written in lowercase and they must not contain any accented characters.
Components
WINDEVWEBDEV - Server code wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment