ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HFree (Function)
In french: HLibère
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Transforms the crossed records (HCross) found in a data file into deleted records. The space occupied by the crossed records is freed and it can be re-used during the next additions (HAdd).
Reminder A scratched Record is inactive and disappears from the index. The data found in this crossed record is not deleted (unlike HDelete).
Example
// Supprime tous les enregistrements rayés du fichier de données "Client"
HFree(Client)
Syntax
<Result> = HFree([<Data file>])
<Result>: Boolean
  • True if the record was deleted,
  • False in the event of a problem: the Record is not deleted. HError is used to identify the error.
<Data file>: Optional character string
Name of the data file used. If this name is not specified, HFree will use the last data file used by the last HFSQL function (function starting with "H").
Remarks
This function is not suitable for the xBase files.
Business / UI classification: Business Logic
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help