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.
zipMerge (Function)
Merges the different sub-archives found in a multi-part archive to create a single-part archive.
ThreadWaitSignal (Function)
Locks the current thread until it receives a signal from another thread.
EmailStartSession (Function)
Starts an email management session based on the selected management mode (POP3, SMTP, IMAP or MS Exchange).
HTTPSend (Function)
Sends an HTTP request and waits for the response from the HTTP server.
Report viewer: "Print" tab
The report viewer allows end users to view reports before printing them......
HChangeName (Function)
Modifies the physical name of a data file.
Reals
FontName (Property)
The FontName property is used to: Identify the font used in a control. Change the font used in a control....
Font (Property)
The Font property is used to Get the identifier of the font used in a control in a report, page or window. Change the font used in a control in a report, page or window....
fDecrypt (Function)
Decrypts a file that was encrypted by fCrypt.
HCreateMasterReplica (Function)
Creates the description file of a Master Replica (logged replication or universal replication).
zipInfoFile (Function)
Returns the characteristics of a file found an archive: The name of the file and its stored path. The initial size of the file. The compressed size of file. The date and time of file creation. The date and time of file modification. The date and time of file access. The file attributes. The file encryption mode....
Confirm (Function)
Displays a message in a standard dialog box that proposes "Yes", "No", "Cancel" and returns the user's choice....
Check Box control properties
Several WLanguage properties can be used on the Check Box controls found in a window, in a page or in a report......
Static control properties
List of properties associated with a Static control...
Creating the Table windows of the WINDEV RAD pattern
Creating the Table pages of the WEBDEV RAD pattern
Page templates and inheritance
When a page template is applied to a page, all the controls and code found in the template are "copied" into the page......
The TreeView Table control
The Treeview Table control is a cross between the Table control and the TreeView control......
Events associated with TreeView controls
List of events associated with TreeView controls...
Creating a table in a report
Tables can be created in a report......
Window templates and inheritance
When a window template is applied to a window, all the controls and code in the template are "copied" to the window......
Check: SMART status of storage drives
The monitoring robot will measure the SMART attributes of a server's hard drives......
restRequest (Type of variable)
The restRequest type is used to define the advanced characteristics of a REST request.
Report based on a text file
In a report based on a text file, the information to print is read from a text file or is directly assigned in the report controls......