SetNew

Takes four parameters, FieldBase, FieldName, Source, IfLenFld

Usage:

FieldBase, FieldName, Source, IfLenFld
[WorkWith], FieldName, Source, IfLenFld
[WorkWith], FieldName, Source, [""]
FieldBase, FieldName, Source, [WorkIf]
[WorkWith], FieldName, Source, [WorkIf]

Description:

Creates a new field in the current work query with the value set to Source.

This is useful when you already have the parent Alias of a relationship that you want to include. You can set your current work query to contain the parent Alias and then call the Children command.

Examples:

SetNew    "MemTab.Person.Alias", `pPersonAlias  'Setting from plain text from Top Query field
Children "MyExample.ChildRelationship"
SetNew  "MemTab.Person.", "BirthdateDuplicate", "Birthdate", "Birthdate" 'Setting from Work Query field