Specifications

Operators used in InfoMaker expressions
618 InfoMaker
Other columns in the rule
You can refer to values in other columns for the
current row by specifying their names in the validation rule:
Table 23-4: Using expressions with values from other columns
Operators used in InfoMaker expressions
An operator is a symbol or word in an expression that performs an arithmetic
calculation or logical operation; compares numbers, text, or values; or
manipulates text strings.
Four types of operators are available:
• Arithmetic for numeric datatypes. See “Arithmetic operators in
InfoMaker expressions” on page 619.
•Relationalfor all datatypes. See “Relational operators in InfoMaker
expressions” on page 619.
• Logical for all datatypes. See “Logical operators in InfoMaker
expressions” on page 623.
• Concatenation for string datatypes. See “Concatenation operator in
InfoMaker expressions” on page 624.
Expression in
Database painter
Expression in Form
painter Description
@column >= 10000 Integer(GetText())>=
10000
If a user enters a salary below
$10,000, an error message
displays.
@column IN (100,
200, 300)
Integer(GetText()) IN
(100, 200, 300)
If a user does not enter a
department ID of 100, 200, or
300, an error message displays.
@salary > 0 Long(GetText()) > 0 If a user does not enter a positive
number, an error message
displays.
Match(@disc_price,
"^[0-9]+$") and
@disc_price <
Full_Price
Match(GetText( ),
"^[0-9]+$") and
Real(GetText()) <
Full_Price
If a user enters any characters
other than digits, or the resulting
number is greater than or equal
to the value in the Full_Price
column, an error message
displays.