UpdateOrNew

Takes two parameters, TableName, IfLenFld

Usage:

TableName, IfLenFld
TableName, [""]
[WorkWith], [""]
TableName, [WorkIf]
[WorkWith], [WorkIf]

Description:

The command either calls Update or New for each Record in the Work Query depending on if the Record Alias already exists in the Database.

Example:

WorkWith "MemTab.Person"
        SetNew          "Alias", `PersonAlias
        SetIf           "Alias", *, "Not Alias"

        Pull            "FirstName Lastname Email Phone"

        Backfill
            UpdateOrNew
        End Backfill
FailIfRecError
End WorkWith