10.7 Conditions

Conditions are used in report programs to make some kind of decision. A condition can be any one of the following:

a single data value

an expression

expression separated by relational operators

conditions separated by logical operators

Data values are represented in conditions the same as they are in expression; however, slightly different rules are applied in the conversion:

If the condition is a single data value, leave the string as a string.

If the string is an operand of a relational operator and the other operand is of type money, convert the string to a money value.

If the string is an operand of a relational operator and the other operand is of type date, convert the string to a date.

If the string is an operand of a relational operator and the other operand is of type time, convert the string to time value.

If the string is an operand of a relational operator and the other operand is a numeric type, convert the string to a real.