KeepIfAll

Takes a variable number of parameters, FieldBase, Test1, Test2, [etc..]

Usage:

FieldBase, Test1, Test2, [etc...]
[WorkWith], Test1, Test2, [etc...]

Description:

Note: Unlike most other statements in MOX, because of the dynamic number of other items you must specify an empty string for the FieldBase when it is not needed and is otherwise set by the WorkWith command.

All Records in the Query that have all of the Test values evaluate to True (not blank) will be kept, all others will be discared. Each Test may be a Field name or a literal. When a Field name is used, placing the operator Not with a space in front the Field name will reverse the logic on that item, such that it will be True if blank.

Example:

KeepIfAll     "MemTab.Person.", "FirstName", "LastName", "ConactInfo", "Not Disabled"