ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

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...
Creating an insert query
An insert query (corresponding SQL statement...
Describing a query
Once a query is created, all the characteristics of this query can be modified at any time...
Example for creating a select query
This help page explains how to create two select queries...
Query creation mode: independent or embedded query
The query editor proposes two methods for creating a query...
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, ...
Operations in a Select query
The query editor allows you to perform operations on the values of an item...
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.
Joins between the tables of a select query
When several tables are used in a query, the query editor automatically searches for the links between these tables defined in the database schema...
Project comparator
Comparing two windows (two pages, two reports, two classes, ...
Optimizing the query execution
The query editor allows you to optimize the execution speed of one or more queries...
Creating a query
Two methods can be used to create a query...
Creating a select query
A select query (corresponding SQL statement...
HSuggestKey (Function)
Returns a list of keys to add to tables to improve query performance.
Test of a query
The query editor allows you to run the test of query result...
Creating a combining query
A combining query (corresponding SQL statement: UNION) ...
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...
Creating a delete query
A delete query (corresponding SQL statement...
Code history
The code history is used to...
Selection conditions of a query
The selection conditions of records are applied to the items used in the queries...
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...
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
Select query description window
The description window of a select query includes several sections...
Environment of the query editor
When creating a class in the code editor, the Constructor and Destructor methods are automatically created by default...
Items used in a select query
A query created in the query editor can contain several types of items...
Creating an update query
An Update query (SQL UPDATE statement) is used to modify the records in a database file...
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...
The Linear Looper control
A Linear Looper control is used to display a set of controls in a horizontal scrolling list......
WINDEV concepts
Native Oracle Connector: Programming with SQL functions
The SQL functions can be used to handle the ORACLE database, regardless of whether WDORAINS is used or not to configure the accessed database......
The HTML Edit control: Automatic formatting toolbar
In HTML Edit controls, a formatting toolbar can be automatically displayed when the control becomes editable......
Reloading a document
To reload a document, ......
AAF: Context menu of Image controls
A context menu is available for Image controls......
Editing pages: Responsive mode (Zoning and layouts)
"Responsive (zoning and layouts)" is the default page editing mode. This editing mode allows you to easily handle pages in the editor....
TriggerScheduledTask structure
The ScheduledTask structure is used to define all the events that will define the execution of a task......
Creating anchors
The anchors are used to define specific points in a help page......
WDInst: including an "autorun" in a setup on CD
An "autorun" can be run (or not) when the setup CD is inserted into the drive of the setup computer......
Metatypes in the analysis
A metatype is a combination of characteristics of an item and a bound control......
Page Footer block
The Page footer block is run at the end of each page......
Container controls
WINDEV, WEBDEV and WINDEV Mobile feature different controls that can contain other controls......
Skin elements
The skin elements are used to quickly change the visual aspect of a project without having to retouch every page and every page template......
The RTF edit control: Automatic formatting toolbar
In RTF Edit controls, a formatting toolbar can now be automatically displayed when the control becomes editable......
HtmlFormat (Property)
The HtmlFormat property is used to: find out whether an edit control accepts the input in HTML format. modify the input format of an edit control....
AutomaticErase (Property)
The AutomaticErase property is used to: find out whether an edit control is in "Automatic erase" mode. modify the "Automatic erase" characteristic of an edit control....