ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

How to create and run an SQL query through programming?
This help page explains how to create and run an SQL query through programming.
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.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
XMLExecuteXPath (Function)
Executes an XPATH query: in an XML document. in an xmlDocument variable....
<Connection variable>.DeleteQuery (Function)
Deletes a query (used by stored procedures) from an HFSQL server.
HDeleteQuery (Function)
Deletes a query (used by stored procedures) from an HFSQL server.
Handling a database from a Java application
You can start developing your application as soon as the WINDEV project is defined as being a Java project......
Check: Connectivity to the external databases (by ODBC)
The monitoring robot will attempt to connect to an external database (MySQL, SQL Server, ......
Search and full-text index
HFSQL proposes a quick search for character strings in the data......
xpathResult (Type of variable)
The xpathResult type is used it find out the result of the execution of an XPATH query.
<Source>.FilterContains (Function)
Defines and enables a "Contains" filter on a data file, view or query.
BuildBrowsingTable (Function)
Creates a Table control from the items of a data file (view or query).
HFilterContains (Function)
Defines and enables a "Contains" filter on a data file, view or query.
Filtering a data file, a view or a query
A filter is used to define by programming a selection of records corresponding to one or more criteria......
Result of a query in test mode
After its execution in test mode (see Running the query test), the result of the query can be......
FileToArray (Function)
Fills an array of classes or structures with the content of an HFSQL data file or query.
<Source>.ActivateFilter (Function)
Enables the filter that was previously created for the specified data file (view or query).
<Source>.Alias (Function)
Creates a logical alias of a data file (or query) or cancels all existing aliases.
HActivateFilter (Function)
Enables the filter that was previously created for the specified data file (view or query).
HAlias (Function)
Creates a logical alias of a data file (or query) or cancels all existing aliases.
sfProcessWorkItemRequest (Type of variable)
The sfProcessWorkItemRequest type is used to describe a query for processing a task to submit to SFExecuteProcess...
6. Chart and Pivot Table
WINDEV Tutorial: WINDEV application: Managing data Lesson 6 - Chart and Pivot Table - 30 min
2. User-friendly editors in practice
User-friendly editors in practice...
Sort order of records found in a select query
To make the result of a query easier to read, the records can be sorted according to one or more items......
<Source>.ListKey (Function)
Returns the list of keys found in a file (query or view) recognized by the HFSQL engine.
<Source>.Modify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
<Source>.RetrieveItem (Function)
Returns the content of an item found in the current record (in the data file, view, query, ...).
IWListDisplay (Function)
Refreshes the display of an "Internal window" control with automatic iteration on a data file or query.