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.
ReturnToCapture (Function)
Stops the current process and forces the input in the specified control, window or page.
SetFocusAndReturnToUserInput (Function)
Stops the current process, sets the focus to the specified control, window or page, and allows the user to enter data.
<DiskFile variable>.ReadLine (Function)
Reads a line from an external file (ANSI or UNICODE).
FTPRemoveDir (Example)
Usage example of the FTPRemoveDir function
<Image variable>.DrawPolygon (Function)
Draws a polygon in an Image variable.
ListSeek (Function)
Searches for an element in a List Box, ListView or Combo Box control (including the values described by gStoredValue).
<Image>.DrawPolygon (Function)
Draws a polygon in an Image control,
SQLModify (Example)
Usage example of the SQLModify function
fDecrypt (Example)
Usage example of the fDecrypt function
fDir (Example)
Usage example of the fDir function
<WDPic variable>.DrawPolygon (Function)
Draws a polygon in a WDPic variable.
<picLayer variable>.DrawPolygon (Function)
Draws a polygon in a picLayer variable.
WDConver : Use in interactive mode
Before you start using WDConver, you must have......
MenuIsMarked (Example)
Usage example of the MenuIsMarked function
HDescribeFullTextIndex (Example)
Usage example of the HDescribeFullTextIndex function
JavaExecute (Example)
Usage example of the JavaExecute function
<Image variable>.DrawPolyline (Function)
Draws a line composed of multiple segments in an Image variable.
<Image>.DrawPolyline (Function)
Draws a line composed of multiple segments in an Image control.
<emailNotesSession variable>.SendMessage (Function)
Sends an email using the Lotus Notes protocol.
<Source>.ChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
fGraphicFilter (Example)
Usage example of the fGraphicFilter function
FTPSize (Example)
Usage example of the FTPSize function
<WDPic variable>.DrawPolyline (Function)
Draws a line composed of multiple segments.
<picLayer variable>.DrawPolyline (Function)
Draws a line composed of multiple segments.
Events associated with an Ad control
WINDEV Mobile manages the following events by default (in order of appearance in the code editor):