CalculatedItemExpression (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

CalculatedItemExpression

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

This content has been translated automatically. Click here to view the French version.

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

CalculatedItemExpression (Property)

In french: FormuleRubriqueCalculée

Not 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).

This property is available for the Native MySQL Connector.

Versions 22 and later

This property is now available for Java applications.

This property is now available for Android applications.

This property is now available in Android Widget mode.

New in version 22

This property is now available for Java applications.

This property is now available for Android applications.

This property is now available in Android Widget mode.

This property is now available for Java applications.

This property is now available for Android applications.

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

Result> = <Data file>.<Item>.CalculatedItemExpression

<Result>: Character string (with quotes)

SQL expression defining the value of the item.

<Manipulated data file>: File name

Name of data file used.

<Manipulated rubric>: Item name

Name of item used.

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

<Manipulated rubric>.CalculatedItemExpression = <SQL expression>

<Manipulated rubric>: Item name

Name of the 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. For more details, see Data model editor: the different types of items.