PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Conditions for using HFreeQuery
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Frees the resources of a query (after the call to HExecuteQuery or HExecuteSQLQuery).
Note: This function is based on HCancelDeclaration.
When should HFreeQuery be used?
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
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
New in version 17
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Versions 18 and later
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 18
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
iPhone/iPad This function is now available for the iPhone/iPad applications.
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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Initializes the query
IF HExecuteQuery(MyQuery) = False THEN
        Error("Error while initializing the query" + CR + HErrorInfo())
        RETURN
END

// Read the first record of the query
HReadFirst(MyQuery)
WHILE NOT HOut()
        // Process on the query record
        ...
        // Read the next record
        HReadNext()
END
HFreeQuery(MyQuery)
Syntax
<Result> = HFreeQuery([<Query Name>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError is used to identify the error.
<Query Name>: Optional character string (with or without quotes)
Name of a query or name of a data source associated with a query (for freeing resources after the call to HExecuteQuery or HExecuteSQLQuery).
If this parameter is not specified, corresponds to the last data file used.
Remarks

Conditions for using HFreeQuery

This function must be used ONLY when the query is not required anymore!
In the following example, HFreeQuery 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, HFreeQuery will operate before the Table control is entirely filled, making this control unusable.
HExecuteSQLQuery("test", "select * from customer")
BuildBrowsingTable(TABLE_Table1, "test")
HFreeQuery("test")
Note: The problem can also occur with a "data source" variable. A "data source" variable declared locally in a process (button click, procedure, method, ...) 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".
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 16
This page is also available for…
Comments
Click [Add] to post a comment