HFree (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFree (Function)

In french: HLibère

Available 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

This function is now available in Windows Store apps mode.

New in version 18

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

This function is now available for Android applications (for HFSQL data files).

This function is now available for Java applications (for HFSQL data files).

This function is now available in Android Widget mode (for HFSQL data files).

New in version 20

This function is now available for Android applications (for HFSQL data files).

This function is now available for Java applications (for HFSQL data files).

This function is now available in Android Widget mode (for HFSQL data files).

This function is now available for Android applications (for HFSQL data files).

This function is now available for Java applications (for HFSQL data files).

This function is now available in Android Widget mode (for HFSQL data files).

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Versions 24 and later

This function is now available for iPhone/iPad applications.

New in version 24

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 occurred: the record is not deleted. HError is used to identify the error.

<Data file>: Optional character string (with or without quotes)

Name of data file used. If this name is not specified, HFree will use the last data file used by the last HFSQL management function (function starting with "H").

Remarks

This function is not suitable for the xBase files.

Business / UI classification : Business Logic

Component : wd260hf.dll