Top Query Attributes, MOX Keywords

[ ? ] Pick First (Top Query)

Parameter is a space separated list of fields to choose from

[!] Assert (Top Query)

Parameter is a comma separated list (using CSV rules and not in quotes) of the fixed hard coded values to select from

[#] Format (Top Query)

Takes 1 parameter, a formatting mask

[$] Currency (Top Query)

Takes one parameter, Source

[AnyRecError]

Takes no parameters.

[CountIf]

Takes one parameter, TestCondition

[DateTime] (Top Query)

Has no parameters

[Date] (Top Query)

Has no parameters

[HtmlOutput]

Takes a variable number of parameters

[If] Assignment (Top Query)

Parameter is divided into two parts, the Test and the Result if True. The test comes prior to the keyword of Then and the Result if True comes after.

[L] Lookup (Top Query)

Takes one parameter.

[Meta]

Takes no parameters

[Me]

Takes no parameters

[TemplateName]

Takes no parameters

[TemplateType]

Takes no parameters

[Time] (Top Query)

Has no parameters

[TQFieldList]

Takes no parameters

[TQFldCount]

Takes no parameters

[TQMessage]

Takes one parameter, Message, or no parameters

[TQName]

Has no parameters

[TQRecCount]

Has no parameters

[TQResult]

Takes either one parameter, ResultValue, or no parameters

[WQFieldList]

Has no parameters

[WQFldCount]

Takes no parameters

[WQMessage]

Takes one parameter, Message, or no parameters

[WQName]

Has no parameters

[WQRecCount]

Has no parameters

[WQResult]

Takes either one parameter, ResultValue, or no parameters

[_#] Format if not blank (Top Query)

Takes 1 parameter, a formatting mask

[_$] Currency if not blank (Top Query)

Has no parameters. If the field is blank it will remain blank.

[_DateTime] If not blank (Top Query)

Has no parameters

[_Date] If not blank (Top Query)

Has no parameters

[_Time] if not blank (Top Query)

Has no parameters

[ ? ] Pick First (Top Query)

[!] Assert (Top Query)

[#] Format (Top Query)

[$] Currency (Top Query)

[AnyRecError]

[CountIf]

[DateTime] (Top Query)

[Date] (Top Query)

[HtmlOutput]

[If] Assignment (Top Query)

[L] Lookup (Top Query)

[Meta]

[Me]

[TemplateName]

[TemplateType]

[Time] (Top Query)

[TQFieldList]

[TQFldCount]

[TQMessage]

[TQName]

[TQRecCount]

[TQResult]

[WQFieldList]

[WQFldCount]

[WQMessage]

[WQName]

[WQRecCount]

[WQResult]

[_#] Format if not blank (Top Query)

[_$] Currency if not blank (Top Query)

[_DateTime] If not blank (Top Query)

[_Date] If not blank (Top Query)

[_Time] if not blank (Top Query)

Contact

Legal