ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Optimizing the query execution
The query editor allows you to optimize the execution speed of one or more queries...
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, ...
Creating an insert query
An insert query (corresponding SQL statement...
Creating a query
Two methods can be used to create a query...
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...
KeyPressed (Function)
Checks which key is pressed.
Server (Property)
The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.)....
Welcome to WINDEV, WEBDEV and WINDEV Mobile
The home page allows you to easily perform the operations for creating and opening projects......
HSeekFirst (Function)
Positions on the first file record whose value for a specific item is greater than or equal to a sought value.
Report with parameters
When printing a report, you have the ability to pass parameters to this report......
Page-by-page deployment
You now have the ability to deploy site sections or individual pages......
StringDelete (Function)
Deletes: all the occurrences of a substring within a string. part of a string within another string. The part of the string to remove is identified by its position and length....
TableToXML (Function)
Creates an XML file from the data found in a Table or TreeView Table control.
Abs (Function)
Returns the absolute value: of a numeric value, of a numeric expression (integer or real). of a duration....
FTPCurrentDir (Function)
Identifies or modifies the current directory on an FTP server (File Transfer Protocol).
HSetPosition (Function)
Sets the position on a record, based on the approximate position of one of its items.
EmailSaveAttachment (Function)
Copies the attachment of current email onto the user computer (locally).
fExtractPath (Function)
Returns the different elements of a path: drive, directories, name and extension of the file.
fExeDir (Function)
Returns the directory from which the execution is started.
Software Factory
The concept of software factory is used to automate the process for creating applications....
ReplicSynchronize (Function)
Synchronizes the data corresponding to a replication.
Events associated with a Multimedia control
List of events associated with a Multimedia control...
Non-maximized windows in iOS
A non-maximized window can occupy a section of the screen only......
Events associated with a Multiline Zone control
WINDEV and WINDEV Mobile manage the following events by default (order of appearance in the code editor):...
4. WINDEV, WEBDEV and WINDEV Mobile: fully compatible format
WINDEV, WEBDEV and WINDEV Mobile: fully compatible format...
Background tasks
Continuing to run a process when the application is in background is very useful on mobile......
OpenPopupAsynchronous (Function)
Opens a popup window whose result will be retrieved via a WLanguage procedure ("callback").