Chapter 3: DataWindow Object Properties

Expression

Description

The expression for a computed field control in the DataWindow. The expression is made up of calculations and DataWindow expression functions. The DataWindow evaluates the expression to get the value it will display in the computed field.

Applies to

Computed field controls

Syntax

PocketBuilder dot notation:

dw_control.Object.computename.Expression

Describe and Modify argument:

"computename.Expression { = ’string ' }"

Parameter	Description
computename	The name of the computed field control in the DataWindow for which you want to get or set the expression.
string	A string whose value is the expression for the computed field.

Usage

In the painter

Select the control and set the value in the Properties view, General tab, Expression option. The More button displays the Modify Expression dialog, which provides help in specifying the expression. The Verify button tests the expression.

Examples

Example 1

setting = dw_1.Object.comp_1.Expression

Example 2

dw_1.Object.comp_1.Expression = "avg(salary for all)"

Example 3

setting = dw_1.Describe("comp_1.Expression")

Example 4

dw_1.Modify("comp_1.Expression='avg(salary for all)'")

View this book as PDF