COLOR WHERE Attribute

The COLOR WHERE attribute defines a condition to set the foreground color dynamically.

Syntax

COLOR = color-name [...] WHERE bool-expr
  1. color-name can be BLACK, BLUE, CYAN, GREEN, MAGENTA, RED, WHITE, or YELLOW.
  2. color-name can also be an intensity keyword: REVERSE, LEFT, BLINK, and UNDERLINE.
  3. bool-expr defines a boolean expression with a restricted syntax.

Usage

The COLOR WHERE attribute defines the logical color of the text of a field when the value satisfies the conditional expression.

The condition in COLOR WHERE can only reference the field for which the attribute is set.

The boolean expression is automatically evaluated at runtime to check when the color attribute must be set.

EDIT f001 = item.price, COLOR=RED WHERE f001 > 100;