Backfill

Has no parameters

Description:

When Updating Records in the Database, only the Fields present in the WorkQuery will be updated, the remaining Fields will keep whatever value was previously in the Database. Optionally, Fields present in the WorkQuery may be set Record by Record to the value of $B in order to indicate that that Field of that Record should also keep whatever value is previously in the Database.

Example:

WorkWith        "Item.List"
SetNew "Alias", `pList
Pull "Name DueDate"
SetNew "Other", ($B)
Backfill
Update
End Backfill
FailIfRecError
End WorkWith