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...
BrowsedItem (Property)
The BrowsedItem property is used to: Get the item used to automatically loop through Table, Looper, List Box, ListView and Combo Box controls, supercontrols and reports based on data files. Change the item used to automatically loop through Table, Looper, List Box, ListView and Combo Box controls, supercontrols and reports based on data files. Then, the iteration is reinitialized....
InputMask (Property)
The InputMask property is used to: get the input mask. set the input mask (from the masks available for the type)....
Name (Property)
The Name property is used to get: the name of the font associated with a Font variable. the name of a control, report or report block. the name of a control, group of controls or window. the name of a control, group of controls or page....
Accessing a database in local mode (SQLite)
WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code....
Choosing the languages supported by the application
The choice of languages supported by the WINDEV or WINDEV Mobile application or by the WEBDEV site is performed at several levels......
XMLExecuteXPath (Example)
Usage example of the XMLExecuteXPath function
NullSupported (Property)
The NullSupported property is used to manage the NULL value in HFSQL data files.
Native XML Connector
WINDEV and WEBDEV allow you to import and handle a definition of XML files via the data model editor......
List of reserved words
H.NumRec (Variable)
Contains the number of the physical record loaded in memory (which means the number of the last record read).
4. Simple printing
WINDEV Tutorial: WINDEV application: Managing data Lesson 4 - Simple printing - 20 min
Managing HFSQL Client/Server databases
The HFSQL Control Center allows you to fully manage HFSQL Client/Server databases......
Native SQL Server Connector: Programming with SQL functions
The SQL functions can be used to handle the SQL Server database......
HReadFirst (Function)
Sets the position on the first record according to a browse item.
HExecuteQuery (Example)
Usage example of the HExecuteQuery function
Compile (Function)
Dynamically compiles an Procedure whose source code is provided (dynamic compilation).
SQLFirst (Example)
Usage example of the SQLFirst function
The Link control
The Link control is used to: create a link in an HTML page. create a link in a report printed in HTML format....
OpenChild (Function)
Opens a non-modal child window.
CacheSize (Property)
The CacheSize property is used to: Get the maximum number of records that can be stored in the cache of the Native MySQL Connector. Change the maximum number of records that can be stored in the cache of the Native MySQL Connector....
HExecuteSQLQuery (Example)
Usage example of the HExecuteSQLQuery function
Use (Function)
Opens a WINDEV window and closes all the other windows that were opened beforehand.
The Combo Box control
The "Combo Box" control is used to display a list of elements and to select an element from this list......
"Project explorer" pane
The "Project explorer" pane is used to simplify the development environment of WINDEV, WEBDEV and WINDEV Mobile......
Type of item: Secure password
"Password" items are used to securely store passwords by using a salt and a hash algorithm......