Specifications

Adding controls to the form
564 InfoMaker
About the Modify
Expression dialog box
The Modify Expression dialog box provides you with lists and buttons to help
you create the computed field:
The Modify Expression dialog box contains:
• A Functions box with a list of built-in functions you can use in the
computed field
• A Columns box with a list of columns, named computed fields, and
retrieval arguments in the form
• Buttons for adding operators and parentheses
Entering the
expression
You can enter any valid expression when defining a computed field. You can
paste operators, columns, existing computed fields, retrieval arguments, and
functions into the expression from information in the Modify Expression
dialog box. You can use the + operator to concatenate strings.
InfoMaker expression
The expression you are entering is an InfoMaker expression; it is not a SQL
expression processed by the DBMS. The expression follows InfoMaker rules.
For complete information about expressions, see Chapter 23, “Operators and
Expressions.”
Examples
Here are some examples of computed fields:
To display Enter this expression
Current date
Today( )
Current time Now( )
Concatenation of Fname and Lname
columns for each row
Fname + " " + Lname