ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

SQL functions: Special case
List of SQL functions: Special case...
<TreeView Table>.TypeItem (Function)
Checks the existence of an element in a TreeView Table and returns its type (node or leaf) if the element exists.
<Scheduler>.DisplayPreviousPeriod (Function)
Moves the time area displayed on the previous area (previous weeks for example) in a Scheduler control.
<Scheduler>.DisplayNextPeriod (Function)
Moves the time area displayed on the next area (next weeks for example) in a Scheduler control.
MapPolygon (Type of variable)
The MapPolygon type is used to define the characteristics of a polygon to be drawn on the map displayed in a Map control.
MapCircle (Type of variable)
The MapCircle type is used to define the characteristics of a circle to be drawn on the map displayed in a Map control.
MapImage (Type of variable)
The MapImage type is used to define the characteristics of an image to be drawn on the map displayed in a Map control.
websocketClient (Type of variable)
The websocketClient type is used to identify and define all the advanced characteristics of a client connected to a WebSocket server.
ChronoEnd (Function)
Stops a stopwatch and returns the time elapsed (in milliseconds) since the start of timing (call to ChronoStart).
FinRedemption (Function)
Creates an amortization matrix for a fixed-rate loan over a defined period of time.
TreeTypeItem (Function)
Checks the existence of an element in a TreeView control and returns its type (node or leaf) if the element exists.
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......
pdfPage (Type of variable)
The pdfPage type is used to define all the advanced characteristics of a page from a PDF document loaded in memory.
TableTypeItem (Function)
Checks the existence of an element in a TreeView Table and returns its type (node or leaf) if the element exists.
Encryption (Property)
The Encryption property allows you to manage the type of encryption used between Client computers and an HFSQL server.
<Gantt chart>.TimeDisplayed (Function)
Defines the time range displayed in a Gantt Chart column in a Table or TreeView Table control.
diagGroup (Type of variable)
The diagGroup type is used to define all the advanced characteristics of a group of shapes in a Diagram Editor control.
WBAdminAccount (Type of variable)
The WBAdminAccount type is used to define all the advanced characteristics of a WEBDEV account in a WEBDEV Application Server.
diagBorder (Type of variable)
The diagBorder type is used to define all the advanced characteristics of a border (or borders) of a shape used in a diagram.
grCategoryColor (Function)
Initializes the category color for a chart whose type is: Pie, Column, Bubble chart, Waterfall....
<Chart>.CategoryColor (Function)
Initializes the category color for a chart whose type is: Pie, Column, Bubble chart, Waterfall....
btleService (Variable type)
The btleService type is used to handle a Bluetooth Low Energy service ("Bluetooth GATT Service").
nfcTag (Variable type)
The nfcTag type is used to define the advanced characteristics of an NFC tag (Near Field Communication).
hdfsConnection (Variable type)
The hdfsConnection type is used to define the advanced characteristics of a connection to the Hadoop file system (HDFS).