EnsureFields

Takes two parameters, FieldBase, FieldNames

Usage:

FieldBase, FieldNames
[WorkWith], FieldNames 
[""], FieldNames

Description:

The new Fields will be added to the far right hand side of the Query in the order specified. The Fields will be empty for each record. If any Field name already exists, it will continue to exists in its previous location and keep its data.

Example:

In the example below, the two EnsureFields are equivalent.

EnsureFields "Biz.TableName.", "Name Age DueDate"

WorkWith "Biz.TableName"
EnsureFields "Name Age DueDate"
End WorkWith