ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

How to create and run an SQL query through programming?
This help page explains how to create and run an SQL query through programming.
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword...
Report based on an SQL query with data accessed via a connection (ODBC, etc.)
A report based on an SQL query with data accessed via a connection can print records from a database accessible via a specific ODBC driver or via a Native Connector...
HExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
SQL functions for accessing the external databases
List of SQL functions used to access the external databases
Cross-database queries
An SQL query can operate on different databases...
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
HSuggestKey (Function)
Returns a list of keys to add to data files to improve query performance.
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
Creating a query in SQL code
The query editor allows you to create a query by typing SQL code...
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
FTPListFile (Example)
Usage example of the FTPListFile function
zipMsgError (Example)
Usage example of the zipMsgError function
BurnerErase (Example)
Usage example of the BurnerErase function
HNbRec (Example)
Usage example of the HNbRec function
iPrintZone (Example)
Usage example of the iPrintZone function
fClose (Example)
Usage example of the fClose function
HInfoServerRights (Example)
Usage example of the HInfoServerRights function
HInfoFileRights (Example)
Usage example of the HInfoFileRights function
fCurrentDrive (Example)
Usage example of the fCurrentDrive function
FinInterestRate (Example)
Usage example of the FinInterestRate function
EmailSaveAttachment (Example)
Usage example of the EmailSaveAttachment function
2. Projects in practice
2. Projects in practice
Discover the main operations that can be performed on a project....
LooperModify (Function)
Changes the values of the attributes in a row of a Looper control.
FTPCommand (Function)
Sends a specific FTP command to a server.
HGetCurrentPosition (Function)
Returns the approximate position of current record in the data file.
ErrorInfo (Function)
Retrieves information about the last error that occurred in a function of a WINDEV, WINDEV Mobile or WEBDEV component.
ServiceContinue (Function)
Restarts a paused service.
<Looper>.Add (Function)
Adds a row at the end of a Looper control.
fUncompress (Example)
Usage example of the fUncompress function
HMergeView (Example)
Usage example of the HMergeView function
HFSQL management functions
List of functions for HFSQL management...
HChangeName (Example)
Usage example of the HChangeName function
fDelete (Example)
Usage example of the fDelete function
Multicolumn report
The report editor allows you to create "Multicolumn" reports....