ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

How to create and run an SQL query through programming?
This help page explains how to create and run an SQL query through programming.
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...
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
<emailOutlookSession variable>.SendMessage (Function)
Sends an email using the Outlook protocol.
INIRead (Example)
Usage example of the INIRead function
<Image variable>.SaveGIF (Function)
Saves an image found in an Image variable: in a file in GIF format. in memory....
FTPCurrentDir (Example)
Usage example of the FTPCurrentDir function
fCompare (Example)
Usage example of the fCompare function
OutlookStartSession (Example)
Usage example of the OutlookStartSession function
<DiskFile variable>.WriteLine (Function)
Writes a line into a text file (ANSI or UNICODE).
<Image>.SaveGIF (Function)
Saves an image: in a file in GIF format. in memory....
MemSeek (Example)
Usage example of the MemSeek function
<DiskFile variable>.Read (Function)
Reads: a block of bytes (characters) in an external file (ANSI or Unicode), the content of an external file (ANSI or Unicode) and assigns it to a memory area....
Aliases on data files: HAlias
The aliases are used to handle......
<Image>.Rotation (Function)
Rotates an Image control.
fReadLine (Example)
Usage example of the fReadLine function
fStopCompress (Example)
Usage example of the fStopCompress function
fSize (Example)
Usage example of the fSize function
fLongName (Example)
Usage example of the fLongName function
Break in a Table control
A break in a Table control is used to group the data corresponding to one or more arguments......
SysMetric (Function)
Returns the resolution of a specific element.
fRename (Example)
Usage example of the fRename function
zipNbPartNeeded (Example)
Usage example of the zipNbPartNeeded function
ExecuteProcess (Function)
Starts the execution of a process programmatically, i.e. without the user having to perform any particular action in the interface.
MatchRegularExpression (Function)
Checks whether a character string matches a specific format and retrieves the different substrings that match the format.
HDeclareExternal (Function)
Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file.
tapiStopCallDetection (Function)
Stops the specified call detection that was started by tapiListen.
HState (Example)
Usage example of the HState function