ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

How to create an SQL query with a calculation formula?
This help page explains how to create a query with a calculation formula with the query editor....
gCircle (Function)
Builds a sequence of characters containing a circle or an ellipse.
FinDecreasingRedemption (Function)
Calculates the amortization value of a good over a specific period of time, via the formula for fixed-rate decreasing amortization.
HErrorLock (Function)
Used to check whether a lock error occurred.
HSetReplication (Function)
Temporarily disables (or re-enables) the replication.
EmailReadLastHeader (Function)
Reads the header of last incoming email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailReadFirstHeader (Function)
Reads the header of the first incoming email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailReadPreviousHeader (Function)
Reads the header of the email found before the current email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
xlsData (Function)
Retrieves the content of a cell found in an XLS file.
HExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
TableInsertColumn (Function)
Inserts elements in the format of columns into a horizontal Table control.
Calculations in the columns of a Table control
When a Table control contains numeric data, it may be useful to get the total of a column or count the number of elements......
EndProgram (Function)
Ends the execution of the current program.
Toast (Type of variable)
The Toast type is used to define all the advanced characteristics of a toast notification.
PageParameter (Function)
Returns the value of a parameter passed to the current page.
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword......
xlsDeleteWorksheet (Function)
Deletes a worksheet from the Excel document.
docElementFormula (Type of variable)
The docElementFormula type is used to define the characteristics of a Formula element found in a DocElement variable.
mongoResult (Type of variable)
The mongoResult type is used to find out the result during a search performed in a MongoDB database.
MQTT constants
Constants used by the MQTT functions...
Financial constants
List of constants used by the financial functions....
ArcTan (Function)
Returns the arc tangent of a numeric value (integer or real).
FTPDisconnect (Function)
Closes the connection between the current computer and the FTP server (File Transfer Protocol).
grOrientation (Function)
Modifies the orientation of chart axes.
LDAPStartAdd (Function)
Initializes the addition of a new object into an LDAP server.