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.
Reports & Queries: New features in this version
"Reports & Queries" software
This is "Reports & Queries"......
HOptimizeQuery (Function)
Optimizes the Select queries by using idle times when handling an application (period without processes).
AllModifiableWithReportsAndQueries (Property)
The AllModifiableWithReportsAndQueries property is used to determine if a report can be modified in Reports & Queries.
HListStoredElement (Function)
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
<Connection variable>.ListStoredElement (Function)
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
Organization chart linked to a data file
TreeView control linked to a data file
You have the ability to create TreeView controls directly linked to the data....
ListView control linked to a data file (or to a query)
A ListView control can be used to display the content of a data file (or the content of a query)......
InterfaceModifiableWithReportsAndQueries (Property)
The InterfaceModifiableWitReportsAndQueries property is used to determine if the interface of a report can be modified in Reports & Queries.
Empty (Property)
The Empty property is used to determine if: a Looper, Table, List Box or Combo Box control is empty. The field can be a file or memory field. a Chart control contains no series. a report control is empty (control linked to an item). an array (or an associative array) contains no element. an element of an associative array exists or not. a queue, a list or a stack contains no element....
Synchronizing the database schema with external databases
The database schema must be synchronized with an external database if it uses......
Native SAP ASE Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native SAP ASE Connector......
Binding a Spin control to an item
A Spin control can be bound to an item in a table, query, etc....
HOptimize (Function)
Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter.
<Source>.Optimize (Function)
Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter.
Binding a Radio Button control to an item
A Radio Button control can be bound to an item in a table, query, etc....
Code history
The code history is used to......