PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
CalculatedItemExpression (Property)
In french: FormuleRubriqueCalculée
ODBCOLE DBNot available with these kinds of connection
The Property CalculatedRubricFormula allows to:
  • Find out the SQL expression that defines the value of an expression item (or calculated item). This item was defined in the data model editor or by programming.
  • Define the SQL expression that gives the value of an expression item (when describing the item by programming).
Native Connectors (Native Accesses) This property is available for the Native MySQL Connector.
Versions 22 and later
WINDEVJava This property is now available for Java applications.
Android This property is now available for Android applications.
Android Widget This property is now available in Android Widget mode.
New in version 22
WINDEVJava This property is now available for Java applications.
Android This property is now available for Android applications.
Android Widget This property is now available in Android Widget mode.
WINDEVJava This property is now available for Java applications.
Android This property is now available for Android applications.
Android Widget This property is now available in Android Widget mode.
Example
AFile is File Description
AnItem is Item Description
AnItem..Name = "CmdDate"
AnItem..CalculatedItemExpression = "'Written by ' + CURRENT_USER + ' on ' + SYSDATE"
AnItem..PersistedCalculatedItem = True
HDescribeItem(AFile, AnItem)
Syntax

Finding out the SQL expression defining the value of a calculated item Hide the details

0
<Result>: Character string (with quotes)
SQL expression defining the value of the item.
<HEX@ data manipulated>: File name
Name of data file used.
<Item manipulé>: Item name
Name of item used.
WINDEVWEBDEV - Server codeReports and QueriesiPhone/iPadUniversal Windows 10 AppWindows MobileAjaxUser code (UMC)

Defining the SQL expression that returns the value of a calculated item Hide the details

<Item manipulé>.CalculatedItemExpression = <SQL expression>
<Item manipulé>: Item name
Name of item used. This name was defined by the Item description type.
<SQL expression>: Character string (with quotes)
SQL expression defining the value of the item.
Remarks
An expression item (or a calculated item) is an item whose content is calculated according to the associated SQL expression and to the values of items in the current record. See Data model editor: the different types of items for more details.
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment