|
|
|
|
|
|
|
|
|
|
CalculatedItemExpression (Property) In french: FormuleRubriqueCalculée
  Not available with these kinds of connection
The CalculatedItemExpression property 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 programmatically.
- Define the SQL expression that gives the value of an expression item (when describing the item through programming).
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
<Résultat> = <Fichier de données>.<Rubrique>.CalculatedItemExpression
<Result>: Character string SQL expression defining the value of the item. <Data file used>: Name of data file Name of the data file used. <Item used>: Item name Name of item used. 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. For more details, see Analysis editor: the different types of sections.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|