Boolean expressions in forms
Some form item definitions can include boolean expressions with a form file specific syntax.
Syntax
[(] bool-expr {AND|OR} bool-expr [)] [...]
where bool-expr is:
[NOT]
{ field-tag
{ = expression
| <> expression
| != expression
| <= expression
| >= expression
| < expression
| > expression
| IS [NOT] NULL
| [NOT] BETWEEN expression AND expression
| [NOT] MATCHES "string"
| [NOT] LIKE "string"
}
}
- field-tag is the name of the current field tag in form line with the attribute definition.
- expression can be the a character string, numeric or date-time literal.
Usage
Some form specification file attributes such as COLOR WHERE
require a boolean expression. These boolean expressions are different from the
language boolean expressions, and have a limited syntax which is specific to
the form files.
When a field-tag is used in the boolean expression, the runtime system replaces field-tag at runtime with the current value in the screen field and evaluates the expression.
Example
EDIT f001 = item.price,
COLOR=RED
WHERE f001 >= 100 AND f001 < 1000;