Top Query Attributes, MOX Keywords

 

[#] Format (Top Query)

Takes 1 parameter, a formatting mask

Read more...

 

[$] Currency (Top Query)

Takes one parameter, Source

Read more...

 

[AnyRecError]

Takes no parameters.

Read more...

 

[CountIf]

Takes one parameter, TestCondition

Read more...

 

 

 

[HtmlOutput]

Takes a variable number of parameters

Read more...

 

[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.

Read more...

 

[L] Lookup (Top Query)

Parameter is the database path that is to be looked up in the form of TableName|Alias|FieldName where it may be a specific fixed path or you may use {} to replace one or more of the path components where the value inside the {} is a field name in the current record.

Read more...

 

[Me]

Takes no parameters

Read more...

 

 

[TQFieldList]

Takes no parameters

Read more...

 

[TQFldCount]

Takes no parameters

Read more...

 

[TQMessage]

Takes one parameter, Message, or no parameters

Read more...

 

[TQName]

Has no parameters

Read more...

 

[TQRecCount]

Has no parameters

Read more...

 

[TQResult]

Takes either one parameter, ResultValue, or no parameters

Read more...

 

[WQFieldList]

Has no parameters

Read more...

 

[WQFldCount]

Takes no parameters

Read more...

 

[WQMessage]

Takes one parameter, Message, or no parameters

Read more...

 

[WQName]

Has no parameters

Read more...

 

[WQRecCount]

Has no parameters

Read more...

 

[WQResult]

Takes either one parameter, ResultValue, or no parameters

Read more...

 

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

Takes 1 parameter, a formatting mask

Read more...

 

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

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

Read more...