CalculatedItemExpression (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

CalculatedItemExpression

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

CalculatedItemExpression (Property)

In french: FormuleRubriqueCalculée

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

This property is available for the Native MySQL Access.

Versions 22 and later

This property is now available for the Java applications.

This property is now available for the Android applications.

This property is now available in Android Widget mode.

New in version 22

This property is now available for the Java applications.

This property is now available for the Android applications.

This property is now available in Android Widget mode.

This property is now available for the Java applications.

This property is now available for the 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> = <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.

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.