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.
TestCheckDifferent (Function)
Checks whether the specified expressions are different in assertive programming and in automated test mode.
ToolTipTitle (Property)
The ToolTipTitle property gets and sets the text displayed in the tooltip associated with the column title of a Table control. This tooltip only appears when the Table control column title is hovered over.
SortType (Property)
The SortType property is used to: Find out the sort direction defined for an item or for a component of a composite key. This item was defined in the data model editor or programmatically. Define the sort direction for an item or for a component of a composite key (when describing the item through programming)....
EventDestroy (Function)
Explicitly destroys an event.
fLoadText (Function)
Loads the content of a text file into any text control or text variable (string variable, edit control in a window, Static control in a report, etc.).
SemaphoreEnd (Function)
Allows one or more threads to exit from the area protected by the semaphore.
HInfoMemo (Function)
Returns the characteristics of binary and text memos.
The Line control
A Line control is used to display a line in a page......
grMask (Function)
Formats the data displayed by grLabel or by grTooltip.
xlsMsgError (Function)
Returns the caption of the last error caused by an XLS function.
HRplPass (Function)
Sets the passwords used to protect the universal replication files.
iPageEnd (Function)
Forces the move to the next page during the report print.
iPageWidth (Function)
Calculates the width (in millimeters) of the printable page while taking the left or right margins into account.
PersistedCalculatedItem (Property)
The PersistedCalculatedItem property is used to: Find out whether the value of a calculated item is stored in the table. This item was defined in the data model editor or programmatically. Define whether the value of a calculated item is stored in the table (when describing the item through programming)....
grClearPict (Function)
Erases the chart drawing (in an Image control or in a window).
iPageHeight (Function)
Calculates the height of printable page (in millimeters) while taking the top or bottom margins into account.
dModifyLightness (Function)
Changes the lightness of an image found: in an Image control, in an Image variable....
Dimension (Function)
Returns the size of a variable (string, numeric, array, ...) or resizes a dynamic array.
TimestampUTC (Property)
The TimestampUTC property is used to: Find out whether a timestamp item will use UTC time or local time. This item was defined in the data model editor or programmatically. Define whether a timestamp item will use UTC time or local time (when describing the item through programming)....
MapDeleteMarker (Function)
Deletes a marker from a map displayed by a Map control.
LooperDeleteAll (Function)
Deletes all rows from a Looper control populated programmatically.
PDFMergeWithPassword (Function)
Merges several password-protected PDF files into a single PDF file.
grDonutHolePercentage (Function)
Modifies the percentage corresponding to the radius of the hole in a Donut chart.
dModifySaturation (Function)
Modifies the saturation of an image found: in an Image control, in an Image variable....
FTPProxy (Function)
Specifies whether the communication functions that use FTP must go through a proxy to run their requests.