ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HPrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
Importing tables into the database schema (external database, etc.)
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ...
<Source>.PrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
MongoFind (Function)
Finds documents in a MongoDB collection.
MongoInfo (Function)
Returns information about a MongoDB database.
MongoDeleteCollection (Function)
Deletes a collection from a MongoDB database.
Unicode (Property)
The Unicode property is used to get and change the Unicode format of an element.
fExtractPath (Example)
Usage example of the fExtractPath function
PageNumber (Property)
The PageNumber property gets and sets a page number.
<Image variable>.SaveBMP (Function)
Saves an image contained in an Image variable: in a file in BMP format. in memory....
gFontItalic (Function)
Builds a sequence of characters used to specify whether or not the text that follows the call to this function is in italic type.
gFontUnderlined (Function)
Builds a sequence of characters to specify whether or not the text that follows the call to this function is underlined.
CellDisplayDialog (Function)
Displays a Cell control in a page with a DDW effect (Dim Disabled Windows). This function is used to easily simulate a dialog box in browser code, by using a Cell control in a page.
sfConnection (Type of variable)
The sfConnection type is used to describe a connection to the Salesforce platform and to manage user authentication...
SysDateTime (Function)
Returns or modifies the system date (current date and time defined on the current computer).
geoGetAddress (Function)
Retrieves an address or a list of addresses corresponding to the description of a geographic location.
CoordinateScreenToEditor (Function)
Converts a size or a position specified in the native dpi of the screen on the device where the application is run to the reference dpi in the editor (160 dpi).
ToolbarVisible (Property)
The ToolbarVisible property is used to: know if the toolbar or the ribbon is displayed in a control. show or hide the toolbar or the ribbon in a control....
grHMColor (Function)
Specifies the colors of different values in a Heatmap chart.
OCRLoadLanguage (Function)
Adds a language to the native OCR system.
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....
Sortable (Property)
The Sortable property is used to: Determine if a Table control column is sortable. Make a column of a Table control sortable or not....
fSaveText (Function)
Creates and fills a text file with the content of a text control or text variable (string variable, edit control in a window, Static control in a report, ...).
HError (Function)
Returns the number of the last error triggered by the HFSQL engine.