Search Results for firstname

 

Build

Takes a variable number of parameters

 

JsonStream

Used to manipulate a WorkQuery into a JSON type

 

NewWithAttach

Takes 4 parameters, TableName, Relation, OtherTableName, IfLenFld

 

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

 

JsonStream$

Used to manipulate a WorkQuery into a JSON type

 

SaveJsonFile

Takes two parameters, FileName, Options

 

SetIf

Takes six parameters, FieldBase, Destination, Source, Left, Comparison, Right

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

 

KeepFields

Takes two parameters, FieldBase, FieldNamesList

 

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

 

[CountIf]

Takes one parameter, TestCondition

 

[If] Assignment (DB Field Attribute)

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.

 

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

 

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.

 

If (Not) / Then

Takes a single Field name, with an optional Not operator, followed by the conditional statement

 

NewEComQuery

Takes one parameter, QueryName

 

ForEach

Takes a variable number of parameters, QueryName, MethodName, [Param1, [Param2, etc...]]

 

Foreign

Takes a single parameter, a QueryName