ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

How to create and run an SQL query through programming?
This help page explains how to create and run an SQL query through programming.
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword...
Report based on an SQL query with data accessed via a connection (ODBC, etc.)
A report based on an SQL query with data accessed via a connection can print records from a database accessible via a specific ODBC driver or via a Native Connector...
HExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
SQL functions for accessing the external databases
List of SQL functions used to access the external databases
Cross-database queries
An SQL query can operate on different databases...
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
HSuggestKey (Function)
Returns a list of keys to add to data files to improve query performance.
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
Creating a query in SQL code
The query editor allows you to create a query by typing SQL code...
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
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).
AppDetectUPDAvailable (Function)
Disables or customizes the automatic check for available updates.
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]....
Handling ListView controls programmatically
WINDEV allows you to programmatically handle ListView controls......
Width (Property)
The Width property gets and changes the width: of a control or block in a report. of a control (found in a window), window, column found in a table or column found in a list box (including listview). of a control (found in a page), column found in a table or column found in a list box. The control can be overlayable or not....
EmailSendMessage (Function)
Sends an email using a given protocol (SMTP, MS Exchange, Lotus Notes, Outlook).
Value (Property)
The Value property is used to: Find out and modify the value of a report control. Find out and modify the value of a control or the title of a window. Find out the identifier of a stream. Find out and modify the value of a control or the title of a page....
WINDEV License Agreement
WINDEV License Agreement...
Tile (Type of variable)
The Tile type is used to defined all the advanced characteristics of a tile for an application in Universal Windows 10 App mode.
6. Printing the product catalog
WINDEV Mobile Tutorial - Developing an Android and iOS application Lesson 6 - Printing the product catalog - 20 min
TelemetryAddPassage (Function)
Signals the code execution for a passage sensor.
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.
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.