ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Creating a query
Two methods can be used to create a query...
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...
(No title )
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...
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 described 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 an insert query
An insert query (corresponding SQL statement...
Creating a select query
A select query (corresponding SQL statement...
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) ...
Selection conditions of a query
The selection conditions of records are applied to the items used in the queries...
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...
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...
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...
Locking an application
WINDEV gives you the ability to lock your applications (after a specific duration for example)......
fGraphicFilter (Function)
Returns the list of image formats supported by the current platform, in the format expected by the filter of fSelect.
grDestinationBMP (Function)
Defines a BitMap file as destination of a chart (BMP means BitMap).
TableInfoXY (Function)
Returns for a given position in a Table or TreeView Table control (coordinates of a control point): the name of the column displayed for the specified position. the index of the row or column for the specified position....
Libraries (.WDL file)
A library is a WDL file that contains all WINDEV or WEBDEV resources ......
MDIOpen (Function)
Opens and enables an MDI child window.
InfoBuild (Function)
Displays a custom message in a system information window.
LooperMoveLine (Function)
Moves a row or swaps two rows in a Looper control.
ChronoResume (Function)
Restarts a stopwatch that was stopped by ChronoEnd or ChronoPause.
FontCharset (Property)
The FontCharset property is used to: Find out the character set used by the screen fonts of a control. Modify the character set used by the screen fonts of a control....
fCreate (Function)
Creates an external file.
FTPRenameFile (Function)
Renames or moves a file found on an FTP server (File Transfer Protocol).
FTPMakeDir (Function)
Creates a directory on an FTP server (File Transfer Protocol).
FTPRemoveDir (Function)
Deletes a directory and its content (files and sub-directories) from an FTP server (File Transfer Protocol).
FTPDeleteFile (Function)
Deletes a file from an FTP server (File Transfer Protocol).
EmailReadNextHeader (Function)
Reads the header of the email found after the current email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
dTextMarkdown (Function)
Draws Markdown text: in an Image control, in an Image variable, in a WDPic variable (on the background layer), in a picLayer variable]....
LooperAdd (Function)
Adds a row at the end of a Looper control.
fUnlock (Function)
Entirely or partially unlocks an external file.
EmailCloseSession (Function)
Closes an email management session depending on the selected mode (SMTP/POP3, IMAP, MS Exchange or Lotus Notes)....
ListModify (Function)
Modifies an element in a List Box, ListView or Combo Box control populated programmatically.
InternetConnected (Function)
Defines whether an Internet connection is enabled on the current computer. In mobile, you can also be notified when the status of the Internet connection changes.
HFlush (Function)
Forces the operating system of the computer where the tables are found to write data onto the disk.
Now (Function)
Returns or modifies the system time (current time defined for the current computer).
ExtractString (Function)
Allows you to: extract a substring from a string based on a specified string separator. search for substrings in a string based on a specified string separator....