ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Query creation mode: independent or embedded query
The query editor proposes two methods for creating a query...
Operations in a Select query
The query editor allows you to perform operations on the values of an item...
Selection conditions of a query
The selection conditions of records are applied to the items used in the queries...
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
Project comparator
Comparing two windows (two pages, two reports, two classes, ...
Items used in a select query
A query created in the query editor can contain several types of items...
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...
Create an insert query
An insert query (corresponding SQL statement...
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...
Joins between the data files of a select query
When several data files are used in a query, the query editor automatically searches for the links between these files defined in the analysis...
HSuggestKey (Function)
Returns a list of keys to add to data files to improve query performance.
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
Describing a query
Once a query is created, all the characteristics of this query can be modified at any time...
Creating a combining query
A combining query (corresponding SQL statement: UNION) ...
Example for creating a select query
This help page explains how to create two select queries...
Test of a query
The query editor allows you to run the test of query result...
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...
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...
The Chart control
The "Chart" control is used to display a chart in windows, pages and reports......
Declaring a procedure/a function
The different syntaxes for declaring a procedure...
AssistedInput (Type of variable)
The AssistedInput type allows you to define all the advanced characteristics of an autocomplete suggestion.
11. Table/Looper controls
HFSQL Client/Server management functions
Several HFSQL functions are used to manage the HFSQL Client/Server data......
Showing passwords (AAF)
By default, in password controls, characters are replaced with dots......
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data......
EmptyIfZero (Property)
The EmptyIfZero property is used to: Find out the management mode of zero value in a control. Modify the management mode of zero value in a control...
The List Box control
The List Box control is used to display a list of elements and to select one or more elements from this list......
Configuring the "Relative duration" mask (date and time in natural language)
WINDEV, WEBDEV and WINDEV Mobile propose to use a "Relative duration" display mask for the Date controls......
Characteristics of Table controls in a page
Table controls allow you to display and/or enter data......
Extensions of files created by WINDEV, WEBDEV, WINDEV Mobile
The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile......
WEBDEV and Google Analytics
Google Analytics is a very popular tool for measuring site traffic......
AssistedInputConfigure (Function)
Used to configure the filter and the opening of assisted input.
AutomaticLink (Property)
The AutomaticLink property is used to: determine if the automatic link detection mode is enabled, enable or disable the automatic link detection mode....
Assisted input management functions (prefix syntax)
The following functions are used to manage the assisted input (prefix syntax) in edit controls...
CheckSpell (Property)
The CheckSpell property is used to enable or disable the automatic spelling checker.
Assisted input management functions
The following functions are used to program assisted input in edit controls...
The Table control populated programmatically
A Table control populated programmatically is directly linked to lists stored in memory......
Characteristics of Table controls in a window
Table controls allow you to display and/or enter data......
Handling the Chart controls at runtime (AAF)
The Chart controls allow the end user to perform several operations......
RTFReplace (Function)
Replaces or inserts a character string in an RTF control (found in a window or in a report) or in a string in RTF (containing a text in RTF).
RTFSelection (Function)
Modifies or lists attributes of text currently selected in an control RTF (from a window or report WINDEV).
Image control in a window
This help page presents the characteristics of an Image control found in a window...
HFSQL Client/Server: Overview
You have the ability to create applications that access the HFSQL Client/Server databases......