Search Results for firstname

 

UpdateOrNew

Takes two parameters, TableName, IfLenFld

 

Build

Takes a variable number of parameters

 

JsonStream

Used to manipulate a WorkQuery into a JSON type

 

JsonStream$

Has one parameter, Options

 

NewWithAttach

Takes 4 parameters, TableName, Relation, OtherTableName, IfLenFld

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

KeepFields

Takes two parameters, FieldBase, FieldNamesList

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

 

SaveJsonFile

Takes two parameters, FileName, Options

 

SetIf

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

 

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

 

KeepIfAll

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

 

KeepUnique

Takes one parameter, FieldName

 

[!] Limited Selection List

Parameter is a comma separated list (using CSV rules and not in quotes) of the options made available to the user which are 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 the field 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.

 

ForEach

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

 

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

 

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.

 

Foreign

Takes a single parameter, a QueryName

 

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

 

[CountIf]

Takes one parameter, TestCondition

 

If (Not) / Then

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

 

NewEComQuery

Takes one parameter, QueryName