ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Create an insert query
An insert query (corresponding SQL statement...
Creating a combining query
A combining query (corresponding SQL statement: UNION) ...
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...
Selection conditions of a query
The selection conditions of records are applied to the items used in the queries...
HSuggestKey (Function)
Returns a list of keys to add to data files to improve query performance.
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...
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
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...
Example for creating a select query
This help page explains how to create two select 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...
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...
Query creation mode: independent or embedded query
The query editor proposes two methods for creating a query...
Describing a query
Once a query is created, all the characteristics of this query can be modified at any time...
Project comparator
Comparing two windows (two pages, two reports, two classes, ...
Test of a query
The query editor allows you to run the test of query result...
Operations in a Select query
The query editor allows you to perform operations on the values of an item...
TimeSys (Function)
Returns or modifies the system time (current time defined for the current computer).
LooperAdd (Function)
Adds a row at the end of a Looper control.
Interacting with the user
WINDEV, WEBDEV and WINDEV Mobile allow you to communicate with the user via dialog boxes......
fRename (Function)
Modifies the name of a file.
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....
ChronoEnd (Function)
Stops a stopwatch and returns the time elapsed (in milliseconds) since the start of timing (call to ChronoStart).
ListModify (Function)
Modifies an element in a List Box, ListView or Combo Box control populated programmatically.
DateSys (Function)
Returns or modifies the system date (current date defined on the current computer).
Today (Function)
Returns or modifies the system date (date of the day defined on the current computer).
fUnlock (Function)
Entirely or partially unlocks an external file.
FTPSize (Function)
Returns the size (in bytes) of a file found on an FTP server (File Transfer Protocol).
HTTPGetResult (Function)
Retrieves the result or the header of last HTTP request run.
EmailCloseSession (Function)
Closes an email management session depending on the selected mode (SMTP/POP3, IMAP, MS Exchange or Lotus Notes)....
TelemetryAddPassage (Function)
Signals the code execution for a passage sensor.
Limitations of WINDEV, WEBDEV and WINDEV Mobile
HTML table
The HTML table is a control used to easily create specific layouts in the HTML pages......
SocketConnect (Function)
Connects a client computer to a given socket.
HSetDuplicates (Function)
Enables or disables the management of duplicates on a unique key.
W3C standardization
You must comply with the W3C standard (HTML 4......
ErrorBuild (Function)
Displays a custom error message in a system error window.
AuthIdentify (Function)
Performs an authentication using the OAuth 2.0 protocol on any webservice.
Working with the Source Code Manager
The principle for working with the Source Code Manager is as follows......
Automatic AJAX
The diagram below presents the automatic and immediate use of AJAX in a WEBDEV site......
HFSQL Client/Server database: Recommendations
This help page presents the main recommendations for optimizing the security and performance of an HFSQL Client/Server database according to the constraints and desired features......
Dashboard control: Automatic Application Features (AAF)
The Dashboard control proposes several Automatic Application Features (AAF) allowing the user to benefit from all control capabilities......