Search Results for separated

 

[Sort] (DB Field Attribute)

Used as a Relationship Attribute, the parameter is a space separated list of field names

 

[Temp] Field

Parameter is a single new field name or a space separated list of new field names.

 

[Sort] (DB Relationship Attribute)

Accepts a space separated list of field names.

 

[Ensure] Field Exists

Takes a variable number of parameters, a comma separated list of TopQuery variable names

 

[SearchSort]

Parameter is a space separated list of field names to have the display table sorted by when displaying search results.

 

[New] Field

Takes one parameter, a comma separated list of FieldNames

 

[FieldList]

Parameter is a space separated list of field names to be displayed.

 

[!] Limited Selection List

Parameter is a comma separated list (without quotes) of the options made available to the user and enforced on save. If the Parameter is just the single word Checkbox, then instead of a drop down list with values, the user will be given a single checkbox; if it is unchecked the value will be blank, and if it is checked the value will be "y". When used with a Top Query in MOX, this will ensure the field value matches one of the options, if not it will throw a run time error.

 

[SearchFieldList]

Parameter is a space separated list of field names to be displayed when the user is viewing results from the Search List.

 

Plus8Decode

Takes three parameters, FieldBase, Fields, IfLenFld

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

Plus8Encode

Takes three parameters, FieldBase, Fields, IfLenFld

 

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

 

MergeFields

Takes 4 parameters, FieldBase, Destination, SourceFields, Delimiter

 

MergeRecords

Takes 5 parameters, FieldBase, GroupBy, MergeField, Delimiter, bKeepBlanks

 

NewFields

Takes two parameters, FieldBase, FieldNames

 

SaveJsonFile

Takes two parameters, FileName, Options

 

XmlMerge

Takes two parameters, [WorkWith]+Scope, EmbedScope

 

Text

Takes six parameters, FieldBase, Destination, Function, Source, Value, IfLenFld

 

WithGroup

Takes six parameters, FieldBase, GroupByField, Destination, Action, Source, IfLenFld

 

HtmlNav

Takes 7 parameters, Location, Mode, Title, TitleLink, Class, HtmlPre, HtmlApn

 

HtmlTable

Takes 6 parameters, Location, Mode, Class, bNoHeader, bNoAutoAlign, bNoIDTags

 

HtmlNavbar

Takes 10 parameters, Location, Mode, Title, TitleLink, Class, Fixed, bNotResponsive, bInverted, HtmlPre, HtmlApn

 

Sort

Takes two parameters, FieldBase, SortFieldList

 

[+] Sum of Field of Attached Child Records

Parameter is the table and field name that you want to sum in the form of TableName.FieldName. The specified Table must be a Child of the calling Record.

 

Public Method

A Public Method may be called from any other Procedure, by the Default plug-in, or a Custom COM DLL. Each Public Method may either use specific Input Parameters, or it may accept an Input Query.

 

[Pull] List of Fields from another Query

Takes up to three parameters, QueryName, FieldBase, FieldNames

 

[Score] 0.0 to 10

Accepts 3 parameters, first is required, 2nd and 3rd are optional.

 

Syntax and Builtin Values, Procedures and Code Documentation

The MOX language pays heritage to BASIC, but has been crafted for the specific type of work and environment that is demanded of Moxie.Build.

 

[A] Copy Attached Value

Parameter must first specify only looking at Parents ( PARENT ) or only looking at Children ( CHILD ). The remainder of the parameter should be the table and field name you are after in the form of TableName.FieldName.

 

[&] Count Attached Child Records

Takes 1 Parameter which is the Table name that you want to count the Attached Records in. The specified Table must be a Child of the calling Record's Table.

 

Format

Takes five parameters, FieldBase, FieldList, Mask, bBlanks2Zero, IfLenFld

 

Group

Takes 7 parameters, FieldBase, GroupBy, GroupTotals, GrandTotals, Seperator, TotalPre, TotalPost

 

JsonStream

Used to manipulate a WorkQuery into a JSON type

 

HttpCookie

Takes 6 parameters, Name, Value, Path, Domain, Expires, Other

 

[WQFieldList]

Has no parameters

 

CsvStream$

Takes one parameter bNoHeaders and returns the result to an assigned variable

 

JsonStream$

Used to manipulate a WorkQuery into a JSON type