Specifications

Where you use expressions
616 InfoMaker
In painters, you use expressions in these ways:
Table 23-1: Using expressions in InfoMaker painters
Other types of expressions you use
You also use expressions in Quick Select, SQL Select, and the Query painter
to specify selection criteria, and in SQL Select and the Query painter to create
computed columns. In these painters you are using SQL operators and
DBMS-specific functions, not operators and functions, to create expressions.
Some of the specific places where you use expressions are described here.
In computed fields
Expressions for computed fields can evaluate to any value. The datatype of the
expression becomes the datatype of the computed field:
Table 23-2: Using expressions in computed fields
Expressions for graphs and crosstabs
You can use similar expressions for series and values in graphs and for
columns, rows, and values in crosstabs.
In this painter Expressions are used in
Report painter Computed fields
Conditional expressions for property values
Filters
Sorting
Series and values in graphs
Columns, rows, and values in crosstabs
Form painter Computed fields
Conditional expressions for property values
Validation rules
Database painter Validation rules
Expression Description
Today ( ) Displays the date using the
Today function
Salary/12 Computes the monthly salary
Sum (Salary for group 1) Computes the salary for the first group using the Sum
aggregate function
Price*Quantity Computes the total cost