Search Results for match

 

InStr%

Takes two parameters, Source, Match

 

TallyAny$

Takes two parameters, Source, Match

 

InStr$

Takes two parameters, Source, Match

 

InStrAny$

Takes two parameters, Source, Match

 

InStrAny%

Takes two parameters, Source, Match

 

JoinQuery

Takes 5 parameters, DestinationQuery, SourceQuery, DestinationMatchField, SourceMatchField, Mode

 

Tally%

Takes two parameters, Source, Match

 

Tally$

Takes two parameters, Source, Match

 

TallyAny%

Takes two parameters, Source, Match

 

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

 

ParseCountAny$

Takes two parameters, Source and Match

 

TrimAny$

Takes two parameters, Source, Match

 

ParseCount%

Takes two parameters, Source and Match

 

ParseCount$

Takes two parameters, Source and Match

 

ParseCountAny%

Takes two parameters, Source and Match

 

New

Takes two parameters, TableName, IfLenFld

 

Children

Takes two parameters, ChildTableName, Mode

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

AppendTable

Takes one parameter, TableName

 

Detach

Takes 3 parameters, ParentTableName, ChildTableName, and a boolean expression (optional)

 

Delete

Takes two parameters, TableName and a boolean expression

 

Parse

Takes seven parameters, FieldBase, Destination, Source, bAny, Delimiter, Item, IfLenFld

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

 

MergeRecords

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

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

WithGroup

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

 

Text

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

 

SaveJsonFile

Takes two parameters, FileName, Options

 

JsonStream

Used to manipulate a WorkQuery into a JSON type

 

Update

Takes two parameters, TableName, IfLenFld

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

KeepFor

Takes two parameters, FromIndex, ToIndex

 

LTrimFields

Takes one parameter, FieldBaseToTrim

 

KeepUnique

Takes one parameter, FieldName

 

KeepIfAny

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

 

ExtractAny$

Takes two parameters, Source , Search

 

Extract$

Takes two parameters, Source, Search

 

JsonEncode$

Has two parameters: Source, Options

 

Lang$

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

JsonStream$

Has one parameter, Options

 

CheckPw$

Takes two parameters, the User Alias, and the User PW to check

 

AppendQuery

Takes 3 parameters, DestinationQuery, SourceQuery, bMoveIt

 

PaaS Method

A PaaS Method may be called by any other Moxie system. In order to call a PaaS Method from MOX, the PaaS statement is used.

 

LookupQuery

Takes six parameters, DestQuery, SourceQuery, DestDestFld, DestXFld, DestYFld, SourceYFld

 

Nightly Management Utility

This utility program manages a server install with one or many Moxie.Build services running by taking care of nightly tasks via a scheduled task

 

[Pull] List of Fields from another Query

Takes three parameters, QueryName, FieldBase, FieldNames

 

LastAny$

Takes two parameters, Source, Search

 

RTrim$

Takes two parameters, Source, Search

 

RetainAny$

Takes two parameters, Source, Search

 

Setup$

Takes one parameter, Name

 

Similar$

Takes 2 parameters, pString1, pString2

 

Similar%

Takes 2 parameters, pNum1, pNum2

 

ReplaceAny$

Takes one existing Source value, and two parameters of equal length, SearchVals, NewVals

 

LTrimAny$

Takes two parameters, Source, Search

 

LTrim$

Takes two parameters, Source, Search

 

Remain$

Takes two parameters, Source and Search

 

Remove$

Takes two parameters, Source and Search

 

RemainAny$

Takes two parameters, Source and Search