<Source>.FreeQuery (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Conditions for using <Source>.FreeQuery

ErrorStatusModification

FilterIncludedBetween

MigrateLinkedCompositeKey

Conditions for using <Source>.FreeQuery

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Source>.FreeQuery (Function)

In french: <Source>.LibèreRequête

Frees the resources of a query (after the call to <Fichier HFSQL>.ExécuteRequête or <Fichier HFSQL>.ExécuteRequêteSQL).

Remark: This function is based on <Source>.AnnuleDéclaration.

When to use <Source>.FreeQuery?
This function can be used when no other process will be using the result coming from a query. We recommend that you use this function on the queries that return an important number of lines (tens of thousands) in order to free the memory space.

Versions 17 and later

This function is now available for Java applications.

This function is now available for Android applications.

New in version 17

This function is now available for Java applications.

This function is now available for Android applications.

This function is now available for Java applications.

This function is now available for Android applications.

Versions 18 and later

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available for iPhone/iPad applications.

New in version 18

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available for iPhone/iPad applications.

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.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

// Initializes the query
IF MyQuery.ExecuteQuery() = False THEN
Error("Error while initializing the query" + CR + HErrorInfo())
RETURN
END

// Read the first record of the query
MyQuery.ReadFirst()
WHILE NOT MyQuery.Out()
// Process on the query record
...
// Read the next record
MyQuery.ReadNext()
END
MyQuery.FreeQuery()

Syntax

<Result> = <Source>.FreeQuery()

<Result>: Boolean

True if the operation was performed,
False if a problem occurred. HError is used to identify the error.

<Source>: Type corresponding to the specified source

Name of a query or a data source associated with a query (for freeing resources after the call to <Fichier HFSQL>.ExécuteRequête or <Fichier HFSQL>.ExécuteRequêteSQL).

Remarks

Conditions for using <Source>.FreeQuery

This function must be used ONLY when the query is not required anymore!

In the following example, <Source>.FreeQuery is used too soon: the table will be completely wrong. Indeed, BuildBrowsingTable (used to fill the Table control) is run in background task in a parallel process. Therefore, <Source>.FreeQuery will operate before the Table control is entirely filled, making this control unusable.

Test.ExecuteSQLQuery("select * from customer")
BuildBrowsingTable(TABLE_Table1, "test")
Test.FreeQuery()

Remark: The problem can also occur with a "data source" variable. A "data source" variable declared locally in a process (button click, procedure, method, etc.) ONLY exists during the execution of this code. For this reason, a "warning" is displayed when you are using this type of data source: "the data source will be destroyed at the end of this code".

Component : wd260hf.dll