[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.

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 = ""

[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

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