[If] Assignment (Top Query)

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.

Description:

The test can take two forms:

  1. Field/Expression (Boolean)
  2. Field/Value Condition Field/Value/Expression (Condition)

When Boolean:

When Condition:

 

Examples:

One = "y"
Two = ""

IsOne  [If] One
NotOne [If] Not One
IsTwo  [If] Two     Then "Yes"
NotTwo [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

[If] $Today = ($Greg (%Greg + 123)) Then "Never"