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.
Project description: Telemetry tab
The project description window allows you to configure various elements of your project......
Project description: Options tab
The project description window allows you to configure various elements of your project......
Project description: Style tab
The project description window allows you to configure various elements of your project......
Extracting the text of the project
The following text can be extracted......
WDOptimizer: Optimizing indices
WDOptimizer includes multiple modes to optimize indices......
Project description: Languages tab
The project description window allows you to configure various elements of your project......
Project description: SCM tab
The project description window allows you to configure various elements of your project......
Project description: Advanced tab
The project description window allows you to configure various elements of your project......
Replication server for the assisted universal replication
The assisted universal replication can use a replication server......
SQLListSource (Function)
Lists the data sources declared on a local site.
SQLChangeConnection (Function)
Modifies the current connection.
WDOptimizer: Overview
The different operations that can be performed with WDOptimizer are as follows......
NullIfEmpty (Property)
The NullIfEmpty property is used to: Find out whether the value returned by the control is NULL if its content is empty. Configure the value returned by the control if its content is empty....
Two-level setup
The two-level setup (or multisite setup) combines: a reference network setup deployed on a local network. an HTTP setup used to update the reference setup on the local network....
The report editor
WINDEV, WEBDEV and WINDEV Mobile allow you to create reports with the report editor......
<Stack variable>.Info (Function)
Retrieves the characteristics of a stack: types of elements and number of elements.
<List variable>.Info (Function)
Retrieves the characteristics of a WLanguage list: types of elements and number of elements.
HExecuteProcedure (Function)
Runs a stored procedure.
Project description: Project tab
The project description window allows you to configure various elements of your project......
ListInfo (Function)
Retrieves the characteristics of a WLanguage list: types of elements and number of elements.
StackInfo (Function)
Retrieves the characteristics of a stack: types of elements and number of elements.
Telemetry: Main features
Environment of the data model editor
Environment of the project editor
The main elements of the project editor are as follows:
Environment of the window editor
The main elements of window editor are as follows: