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
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 crossed record is inactive and it disappears from the index. The data found in this crossed record is not deleted (unlike HDelete).
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: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help