These pages refer to legacy Hydra and Lycia 1 features.
The functionality described here does not embrace all the functionality provided by Lycia 3.
If you use Lycia 3, please, turn to other sections of this online documentation.
These pages refer to legacy Hydra and Lycia 1 features. The functionality described here does not embrace all the functionality provided by Lycia 3. If you use Lycia 3, please, turn to other sections of this online documentation.
Conditional COLOR attributes can specify SQL Boolean operators that are not valid in ordinary 4GL Boolean expressions. You can use the BETWEEN…AND operator to specify a range of number, time, or character values. Here the first expression cannot be greater than the second (for number expressions), later than the second (for time expressions), or later in the code-set order than the second (for character expressions).
The WHERE clause of a COLOR field description can also use the IN operator to specify a comma-separated list (enclosed between parentheses) of values with which to compare the field tag or expression.
Set Membership and Range Tests describes the syntax of the BETWEEN…AND and IN Boolean operators in conditional COLOR specifications for 4GL forms.