• Deleting a data file
  • Names of files and directories on the LINUX server
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
<Connection variable>.DeleteFile (Function)
In french: <Variable Connexion>.SupprimeFichier
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.
MyConnection is Connection
// Deletes data files from the server
WINDEVWEBDEV - Server codeHFSQL Client/Server
Ct_test is Connection
IF Ct_test.DeleteFile(".\Customer.FIC") = False THEN
<Result> = <Connection>.DeleteFile(<Data 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>: Connection variable
Name of the Connection variable that describes the connection in which the data file must be deleted.
<Data file path>: Character string
Physical 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:
hDeleteLogDeletes the Log file and all the logged operations associated with the deleted data file.
hDestroyLinkDeletes all links related to the deleted data file.
hKeepTRSKeeps the transaction file associated with the deleted data file.

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 <Connection variable>.DeleteFile. 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.
Component: wd270hf.dll
Minimum version required
  • Version 25
This page is also available for…
Click [Add] to post a comment