ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Environment of the query editor
When creating a class in the code editor, the Constructor and Destructor methods are automatically created by default...
Creating a query
Two methods can be used to create a query...
Creating an update query
An Update query (SQL UPDATE statement) is used to modify the records in a database file...
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...
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...
Select query description window
The description window of a select query includes several sections...
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...
Test of a query
The query editor allows you to run the test of query result...
Describing a query
Once a query is created, all the characteristics of this query can be modified at any time...
Query creation mode: independent or embedded query
The query editor proposes two methods for creating a query...
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...
Items used in a select query
A query created in the query editor can contain several types of items...
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.
Creating a combining query
A combining query (corresponding SQL statement: UNION) ...
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...
Example for creating a select query
This help page explains how to create two select queries...
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...
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
Handling the versions of a window, report, query or project
When creating and developing the different elements of a project (window, query, report, project, ...
Creating a delete query
A delete query (corresponding SQL statement...
Optimizing the query execution
The query editor allows you to optimize the execution speed of one or more queries...
Creating a select query
A select query (corresponding SQL statement...
XMLData (Example)
Usage example of the XMLData function
XMLSavePosition (Example)
Usage example of the XMLSavePosition function
XMLChild (Example)
Usage example of the XMLChild function
XMLRestorePosition (Example)
Usage example of the XMLRestorePosition function
XMLBuildString (Example)
Usage example of the XMLBuildString function
iParameter (Example)
Usage example of the iParameter function
<WDPic variable>.Font (Function)
Declares the font that will be used by dText in a WDPic variable.
<picLayer variable>.Font (Function)
Declares the font that will be used by dText in a picLayer variable.
NbAnimationSteps (Property)
The NbAnimationSteps property is used to get and specify the number of drawings in the image that defines the animation of a custom infinite Progress Bar control.
HWrite (Function)
Writes a record into a data file without updating the indexes corresponding to all keys used in the file.
Code coverage
The code coverage is the measure regarding the coverage of tests run on an application or site......
FTPDeleteFile (Example)
Usage example of the FTPDeleteFile function
XMLFind (Example)
Usage example of the XMLFind function
1. Implementing a Client/Server database
WEBDEV Tutorial - Managing an HFSQL Client/Server database Lesson 1 - Implementing a Client/Server database - 10 min...
FontSize (Property)
The FontSize property is used to: Identify the size of the font used in a control. Change the size of the font used in a control....
SysNumberScreen (Function)
Returns the number of screens currently connected to the current computer.
<Looper>.AddLine (Function)
Adds a row at the end of a Looper control.
zipClose (Example)
Usage example of the zipClose function
fTempFile (Example)
Usage example of the fTempFile function
HFSQL Control Center: Open an analysis
The HFSQL Control Center allows you to fully manage an analysis......
The Java Applet control
A Java Applet control allows you to easily include Java Applets in your WEBDEV sites......
Scheduler control: Customize appointments
In the Scheduler control, the appointment is displayed in a specific area......
Erase patches
To quickly modify the operating mode of an application, you can use application patches......
NbWorksheet (Property)
The NbWorksheet property is used to get the number of worksheets in a Spreadsheet control.
CtDescribedPassword (Property)
The CtDescribedPassword property allows you to set the password used to open the data file in an OLE DB connection (file defined in the code only).