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...
ChronoReset (Function)
Stops and resets a running stopwatch.
FontStrikeOut (Property)
The FontStrikeOut property is used to: Determine if the text displayed is struck through. Apply strikethrough formatting (or not) the text displayed in a control....
SysDateTime (Function)
Returns or modifies the system date (current date and time defined on the current computer).
LooperInsertLine (Function)
Inserts a row into a Looper control.
LoadParameter (Function)
Reads a persistent value.
dRotation (Function)
Performs a rotation: of an Image control. of an Image variable. of a picLayer variable....
Right (Function)
Extracts the last characters from a string or string buffer.
UnicodeToAnsi (Function)
Converts: a UNICODE string to ANSI (Windows). a buffer containing a UNICODE string to a buffer containing an ANSI string (Windows)....
HError (Function)
Returns the number of the last error triggered by the HFSQL engine.
SQLDisconnect (Function)
Closes the current connection and frees the memory used by the connection.
EmailSaveAttachment (Function)
Copies the attachment of current email onto the user computer (locally).
HListLink (Function)
Returns the list of links (Merise) in the current analysis or in a specific analysis
HListTrigger (Function)
Returns the list of triggers applied to one or more HFSQL data files.
WINDEV 2024 Tutorial - Table of contents
29. SEO in practice
Reintegrating text into a project
All the text form the translation file can be reintegrated into a project......
SaaSIsConnected (Function)
Defines whether the connection to the SaaS web service is still established.
zipExtractFileList (Function)
Extracts and decompresses a list of files found in an archive to a physical location.
FTPSend (Function)
Transfers a file or directory to an FTP server (File Transfer Protocol).
EmailDeleteMessage (Function)
Deletes the current email using the current protocol (POP3, IMAP, MS Exchange, Lotus Notes or Outlook).
HRead (Function)
Reads a record in a file according to a given record number.
Manipulating Dashboard controls programmatically
To programmatically manipulate Dashboard controls, WINDEV, WEBDEV and WINDEV Mobile include dashboard-specific functions......
WDSetup: Managing additional languages
The "WDSetup" project corresponds to the standard setup program of WINDEV applications......
YInitial (Property)
The YInitial property is used to: Find out the Y-coordinate: of a control (position on Y-axis) when opening the window or the page. of a window (position on Y-axis) when opening the window. Modify the Y-coordinate of a control anchored "to bottom" (position on the vertical axis) when opening the window. Find out the Y-coordinate of a control in relation to its block (position in millimeters on the vertical axis) when opening the report....
Navigation map
The site map path is used to implement the structure and the sequence of pages in your site......