[If] Assignment (DB Field Attribute)

Parameter is divided into two parts, the Test and the Result if True. The test comes prior to the keyword of Then and the Result if True comes after.


The first part of the Test must be a field name in the current scope, a string literal without any spaces, or a number. The next item after a space must be a valid comparison. The final item after another space may be a field name in the current scope, a string literal, a number, or an expression in parentheses. The Result may be either a field name, a string literal, or an expression.

If a boolean True/False is desired to be assigned to the Field, then only state the Test and do not use the Then keyword or a Result. If the Test evaluates to True it will be set to the single character of "y" otherwise it will be cleared.


List of Comparisons:

The list of Condition operators, Text and Math, are generic across other If commands in MOX, and are documented on the Syntax page. Note the separate list of Math vs. Text operators; the Math operators are doubled-up.



One = "y"
Two = ""

[If] One
[If] Not One
[If] Two     Then "Yes"
[If] Not Two Then "Yes"

OneIsOne  [If] One = One
OneNotOne [If] One <> One
OneIsTwo  [If] One = Two
OneNotTwo [If] One <> Two

TwoSolve      [If] Two = ($SessionIsBad) Then "Yes"
IsExpression  [If] ($SessionIsBad) Then "Yes"
NotExpression [If] Not ($SessionIsBad)