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.
Indirection operators
The { and } operators are used to access a control, a variable, a class member or a file item by dynamically building the name of control, variable, class member or item...
ListInsert (Function)
Inserts an element into a List Box, ListView or Combo Box control populated programmatically.
OrganizerBackgroundColor (Function)
Defines a background color for a time slot in an Organizer control.
HReadLast (Example)
Usage example of the HReadLast function
fCopyFile (Example)
Usage example of the fCopyFile function
ContactAdd (Example)
Usage example of the ContactAdd function
FinDecreasingRedemption (Example)
Usage example of the FinDecreasingRedemption function
dbgStartMemoryDiff (Function)
Starts a difference operation of the memory used by the application.
WinOutWidth (Function)
Returns the full width of a window (including the border).
HOut (Example)
Usage example of the HOut function
zipSplit (Example)
Usage example of the zipSplit function
fEncrypt (Example)
Usage example of the fEncrypt function
SysIconAdd (Example)
Usage example of the SysIconAdd function
EmailSendMessage (Example)
Usage example of the EmailSendMessage function
Use WebSockets with the WebSocket server
The WebSocket protocol provides a communication channel over a TCP socket for browsers and Web servers......
Constants for managing tiles
Consuming a web service
WINDEV Tutorial: Consuming a web service Consuming a web service - 10 min
CurrentTitle (Function)
Modifies the title of the current window (returned by CurrentWin) and the title bar.
fUncompress (Function)
Decompresses a file that was compressed by fCompress.
EmailReadPrevious (Function)
Reads the email found before the current email according to the protocol used (POP3 or IMAP, MS Exchange, Lotus Notes or Outlook).
ChronoValue (Function)
Indicates the time elapsed (in milliseconds) since the call to ChronoStart.
7. Consuming a web service
WINDEV Mobile tutorial: Developing an Android and iOS application Lesson 7 - Consuming a web service - 10 min
SchedulerAddResource (Function)
Adds a new resource into a Scheduler control.
fCompress (Example)
Usage example of the fCompress function
fListFile (Example)
Usage example of the fListFile function