Page History

...

For instance "#A *LT 10" is a condition. Either field #A is less than 10 (true) or it isn't (false). A condition may contain the following operators for RDML commands:

              *GT,>

              *LT,<

              *EQ,=

              *NE,^=

              *GE,>=

              *LE,<=

We recommend the use of the first operator for cross-platform use. That is, "#A *LT 10", not "#A < 10"

...

Often an expression is contained within a condition. Consider the condition:

                #A  <                      ^{#A  <  ((#B + 10.62) / 3.14)}

               |       |                                    ^{|            |                             |  |}               |       |                  

                  ^{|            |                             |  |}

               |                          ^{|            ---}  expression ^{expression ---  |}

               |                            |

                  ^{|                                             |}

                   ^{-                ---------}  condition^{condition----------}

The components of a condition or an expression can be:

...

An RDMLX object allows RDMLX Enhanced Expressions. Enhanced expressions add support for:

...

Note also that fields allowing SQL Null may behave differently in conditions and expressions at execution time when they are SQL Null. Refer to Assignment, Conditions, and Expressions with Fields allowing SQL Null for details.