ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Carrying over the differences from an element to another one
The project comparator is used to compare two elements and to list the differences found...
Creating a query
Two methods can be used to create a query...
Creating an update query
An Update query (SQL UPDATE statement) is used to modify the records in a database file...
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...
Modifying the values displayed in the result of a select query
In the result of a select query, you have the ability to only display...
Select query description window
The description window of a select query includes several sections...
Operations in a Select query
The query editor allows you to perform operations on the values of an item...
Query creation mode: independent or embedded query
The query editor proposes two methods for creating a query...
Items used in a select query
A query created in the query editor can contain several types of items...
Select query: Displaying the first/last n records
The editor of Select queries is used to limit the number of records that will be displayed in the result of the query.
Creating a combining query
A combining query (corresponding SQL statement: UNION) ...
Creating a select query
A select query (corresponding SQL statement...
Example for creating a select query
This help page explains how to create two select queries...
Query: Displaying the records corresponding to a given period
When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period...
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
Handling the versions of a window, report, query or project
When creating and developing the different elements of a project (window, query, report, project, ...
Creating a delete query
A delete query (corresponding SQL statement...
Optimizing the query execution
The query editor allows you to optimize the execution speed of one or more queries...
Environment of the query editor
When creating a class in the code editor, the Constructor and Destructor methods are automatically created by default...
<Queue variable>.Dequeue (Function)
Dequeues an element from a queue.
Configuring the AAF menus (Automatic Application Features)
WINDEV includes several Automatic Application Features (AAFs)......
Search and full-text index
HFSQL proposes a quick search for character strings in the data......
SFExecuteQuery (Function)
Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database.
<sfConnection variable>.ExecuteQuery (Function)
Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database.
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
Select query description window: Items used
Selection (Property)
The Selection property is used to get the characteristics of the selection (or cursor): in a Word Processing control. Remark: This selection is in the section being edited in the control (body, header or footer). in a Spreadsheet control. in an HTML Editor control. in a Diagram Editor control....
Select query description window: Use
Let's see some operations specific to the description window of a select query......
Select query description window: Items that can be used
SQLClose (Function)
Declares the end of the query execution and frees the memory resources allocated during the execution of the query.
SFForwardQuery (Function)
Continues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database.
<sfConnection variable>.ForwardQuery (Function)
Continues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database.
Reports & Queries: Specific features
This help page presents the specific features of "Reports & Queries" (which means the user version of report editor) ......
Cross-references in the code editor
The cross-references in the code editor are used to identify......
Report viewer: "Annotate" tab
Does your application allow you to print several reports? The end user has the ability to write annotations from the report viewer......
Running a query and handling the result in WLanguage
The selection of records performed by query is not necessarily displayed in a report, in a window, ......
Selection conditions of a query
The selection conditions of records are applied to the items used in the queries......
Report editor: options and keyboard shortcuts
Several toolbars are displayed in the report editor......
AS/400: Development method
The Native AS/400 Connector simplifies access to AS/400 data from your WINDEV and WEBDEV applications......
Search in the editors
Being able to perform a search in the editors significantly improves efficiency......
The Chart control: Characteristics in the editor
Regardless of the type of chart displayed in the Chart control, all its characteristics can be configured via its description window......
In depth look at windows, pages and reports
WINDEV, WINDEV Mobile and WEBDEV allow you to create custom interfaces with the window editor and the page editor......
Select query description window: Actions applied
This help page presents the actions that can be performed from the description window of a query....
Operations in a Select query : add and delete
The following paragraphs present......
1
5
6
7
8
9
131
>