PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

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
..CalculatedItemExpression is used 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 Access.
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

<Result> = <File Name>.<Item Name>..CalculatedItemExpression
<Result>: Character string (with quotes)
SQL expression defining the value of the item.
<File Name>: Character string (with or without quotes)
Name of data file used.
<Item Name>: Character string (with or without quotes)
Name of item used.
WEBDEV - Server codeAjax

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

<Item Name>..CalculatedItemExpression = <SQL Expression>
<Item Name>: Character string (with or without quotes)
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