Search Results for firstname

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

UpdateOrNew

Takes two parameters, TableName, IfLenFld

 

Build

Takes a variable number of parameters

 

[ ? ] Pick First (Top Query)

Parameter is a space separated list of fields to choose from

 

JsonStream$

Has one parameter, Options

 

NewWithAttach

Takes 4 parameters, TableName, Relation, OtherTableName, IfLenFld

 

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

 

[L] Lookup (Top Query)

Takes one parameter.

 

[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 (using CSV rules and not in quotes) of the options made available to the user which are enforced on save.

 

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

 

Help with Markdown

Markdown enables simple formatting of plain text via easy to remember conventions. This page will provide you with some pointers on what formatting options are available with "Moxie Flavored Markdown".

 

MOX Coding and Programing Language Syntax Documentation

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

 

ForEach

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

 

[CountIf]

Takes one parameter, TestCondition

 

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

 

NewEComQuery

Takes one parameter, QueryName

 

Foreign

Takes a single parameter, a QueryName

 

If (Not) / Then

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