ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2026
Creating a delete query
A delete query (corresponding SQL statement...
HSuggestKey (Function)
Returns a list of keys to add to data files to improve query performance.
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, ...
Creating a query
Two methods can be used to create a query...
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...
Handling the versions of a window, report, query or project
When creating and developing the different elements of a project (window, query, report, project, ...
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...
Code history
The code history is used to...
Environment of the query editor
Creating a select query
A select query (corresponding SQL statement...
Query creation mode: independent or embedded query
The query editor proposes two methods for creating a query...
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...
Optimizing the query execution
The query editor allows you to optimize the execution speed of one or more queries...
Select query description window
The description window of a select query includes several sections...
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...
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...
Test of a query
The query editor allows you to run the test of query result...
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.
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...
Creating an update query
An Update query (SQL UPDATE statement) is used to modify the records in a database file...
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...
WHelp (Function)
Displays a file or a help page in HLP or CHM format.
ExecuteProcess (Function)
Starts the execution of a process programmatically, i.e. without the user having to perform any particular action in the interface.
HDeclareExternal (Function)
Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file.
HReset (Function)
Initializes: one or all variables of file items with their default values. one or all items of a Record variable with their default values....
Testing and debugging a WINDEV project on the user computer
WINDEV offers multiple possibilities to test and debug a project directly on the development computer (see Testing and debugging a WINDEV executable on the development computer)......
tapiStopCallDetection (Function)
Stops the specified call detection that was started by tapiListen.
HState (Example)
Usage example of the HState function
zipIsMulti (Example)
Usage example of the zipIsMulti function
HListServerTrigger (Function)
Lists the different triggers available on a connection or on one of the connection files.
GanttWorkingHour (Function)
Overwrites the working hours on a row in a Gantt Chart column of a Table (or TreeView Table) control.
SpreadsheetAddWorksheet (Function)
Adds a worksheet into a Spreadsheet control found in a window.
SpreadsheetInsertWorksheet (Function)
Inserts a worksheet into a Spreadsheet control found in a window.
zipNbPartNeeded (Example)
Usage example of the zipNbPartNeeded function
Body block
The Body block corresponds to the main block of the report......
grWndSize (Function)
Defines the size of the window containing the chart.
iTransparentMagenta (Function)
Modifies the management mode of Magenta color in order for this color to be considered as being transparent (or not) in all the forthcoming prints.
iDidotFont (Function)
Selects the unit that will be used for the height of the fonts (created by iCreateFont): DIDOT point or PICA point.
<Image variable>.SaveBMP (Function)
Saves an image contained in an Image variable: in a file in BMP format. in memory....
FTPCommand (Example)
Usage example of the FTPCommand function
fCreate (Example)
Usage example of the fCreate function
HRecNum (Example)
Usage example of the HRecNum function
fAttribute (Function)
Returns or modifies the attributes of a file.
Specific features of Android applications
The development of Android and WINDEV Mobile applications is different in the following fields......
<Image>.SaveBMP (Function)
Saves an image: in a file in BMP format. in memory....
<Image variable>.SavePNG (Function)
Saves an image found in an Image variable: in a PNG file. in memory....
1
…
83
84
85
86
87
…
132
>