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...
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...
SQL functions for accessing the external databases
List of SQL functions used to access the external databases
HExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
Cross-database queries
An SQL query can operate on different databases...
HSuggestKey (Function)
Returns a list of keys to add to tables to improve query performance.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
Report viewer: "Export" tab
The "Export" pane in the report viewer allows you to perform the following operations......
SQLDisconnect (Function)
Closes the current connection and frees the memory used by the connection.
Generating a library
Generating a library consists in selecting the elements handled by this application (windows, reports, classes, sets of procedures, queries, data files......
Natif DB2 Connector for WINDEV and WEBDEV
WINDEV and WEBDEV propose an optional Native Connector to DB2......
Project description: Files tab
The project description window allows you to configure various elements of your project......
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....
SQLChangeConnection (Function)
Modifies the current connection.
SQLListSource (Function)
Lists the data sources declared on a local site.
<List variable>.Info (Function)
Retrieves the characteristics of a WLanguage list: element types and number of elements.
<Stack variable>.Info (Function)
Retrieves the characteristics of a stack: types of elements and number of elements.
ListInfo (Function)
Retrieves the characteristics of a WLanguage list: element types and number of elements.
StackInfo (Function)
Retrieves the characteristics of a stack: types of elements and number of elements.
Replication server for the assisted universal replication
The assisted universal replication can use a replication server......
Project description: Languages tab
The project description window allows you to configure various elements of your project......
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......
Project description: Compilation tab
The project description window allows you to configure various elements of your project......