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.
FinPeriodInterest (Example)
Usage example of the FinPeriodInterest function
16. Java applications in practice
Java applications in practice...
ServiceStop (Function)
Stops a service.
fStopCompress (Function)
Stops the operation used to compress or decompress a file.
HErrorDuplicates (Example)
Usage example of the HErrorDuplicates function
HListItem (Example)
Usage example of the HListItem function
fRemoveDir (Example)
Usage example of the fRemoveDir function
iPrintPDF (Function)
Prints the content: of a PDF file. of a buffer containing a PDF. of a PDF Reader control....
MapLicenseGgl (Function)
Indicates the "Google Maps API" license key that will be used in the Map controls (of WINDEV or WEBDEV).
HListFile (Function)
Returns the list of files: found in the current analysis or in a specific analysis recognized by the HFSQL engine. The files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. available on a connection via a native access or via an OLE DB driver. for a group of files defined in the data model editor....
iCreateFont (Function)
Creates a new print font.
ServiceStart (Function)
Starts a service.
iParameter (Function)
Retrieves the printer configuration and configures the print.
SpeechRecognitionAddCommand (Function)
Adds a voice command into the current window.
ExeInfo (Function)
Retrieves the specified information about the version of an executable or DLL.
MessTranslate (Function)
Retrieves a message found in the code of a program in the current language.
fListFile (Function)
Lists the files found in a directory and returns the list of files.
fCopyFile (Function)
Copies one or more files (regardless of their attributes).
iFont (Function)
Selects the default font.
Report controls
Several types of controls can be handled in a report created by the report editor......
ServiceRestart (Function)
Restarts a service (already started).
OrganizerZoom (Function)
Returns the time range displayed by an Organizer control.
zipAddFile (Example)
Usage example of the zipAddFile function
fWrite (Example)
Usage example of the fWrite function
zipExtractPath (Example)
Usage example of the zipExtractPath function