PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
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
HFree (Function)
In french: HLibère
AjaxNot available
HFSQLHFSQL 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 crossed record is inactive and it disappears from the index. The data found in this crossed record is not deleted (unlike HDelete).
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.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 20 and later
Android This function is now available for Android applications (for HFSQL data files).
Java This function is now available for Java applications (for HFSQL data files).
Android Widget This function is now available in Android widget mode (for HFSQL data files).
New in version 20
Android This function is now available for Android applications (for HFSQL data files).
Java This function is now available for Java applications (for HFSQL data files).
Android Widget This function is now available in Android widget mode (for HFSQL data files).
Android This function is now available for Android applications (for HFSQL data files).
Java This function is now available for Java applications (for HFSQL data files).
Android Widget This function is now available in Android widget mode (for HFSQL data files).
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.
Versions 24 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 24
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Example
// Delete all crossed records from "Customer"
HFree(Customer)
Syntax
<Result> = HFree([<Data file>])
<Result>: Boolean
  • True if the record was deleted,
  • False if a problem occurs: 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: wd270hf.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment