ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Example 1: Initializing and browsing a query on HFSQL data files
  • Example 2: Initialization and browsing a query on an OLE DB file
HExecuteQuery (Example)
Example 1: Initializing and browsing a query on HFSQL data files
HFSQL ClassicHFSQL Client/ServerStored procedures The following example is used to initialize a query and to browse it.
// Initializes the query
IF HExecuteQuery(QRY_MyQuery) = False THEN
Error("Error while initializing the query" + CR + HErrorInfo())
RETURN
END
 
// Read the first record of the query
HReadFirst(QRY_MyQuery)
WHILE NOT HOut()
 // Process on the query record
 ...
 // read the next record
 HReadNext()
END
HCancelDeclaration(QRY_MyQuery)
Example 2: Initialization and browsing a query on an OLE DB file
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