Search Results for match

 

JoinQuery

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

 

InStr$

Takes two parameters, Source, Match

 

InStr%

Takes two parameters, Source, Match

 

InStrAny%

Takes two parameters, Source, Match

 

InStrAny$

Takes two parameters, Source, Match

 

TallyAny%

Takes two parameters, Source, Match

 

Tally$

Takes two parameters, Source, Match

 

Tally%

Takes two parameters, Source, Match

 

TallyAny$

Takes two parameters, Source, Match

 

ParseCountAny$

Takes two parameters, Source and Match

 

ParseCount$

Takes two parameters, Source and Match

 

ParseCountAny%

Takes two parameters, Source and Match

 

TrimAny$

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. To use different values than labels, for each comma separated pair, specify the value first inside of { } followed by the label.

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 this attribute is used with a Top Query in MOX, it will ensure the field value matches one of the options; if not, it will throw a run time error.

 

ParseCount%

Takes two parameters, Source and Match

 

New

Takes two parameters, TableName, IfLenFld

 

Detach

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

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

AppendTable

Takes one parameter, TableName

 

Children

Takes two parameters, ChildTableName, Mode

 

Delete

Takes two parameters, TableName and a boolean expression

 

ChildrenAlias

Takes two parameters, ChildTableName, Mode

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

Parse

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

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

MergeRecords

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

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

 

WithGroup

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

 

Lang

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

SaveJsonFile

Takes two parameters, FileName, Options

 

Text

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

 

JsonEmbed

Has six parameters, UniqueParent, DestField, FieldBase, UniqueChild, EmbedFields, Options

 

KeepFields

Takes two parameters, FieldBase, FieldNamesList

 

Update

Takes two parameters, TableName, IfLenFld

 

DeleteFields

Takes two parameters, FieldBase, FieldNameList

 

KeepUnique

Takes one parameter, FieldName

 

LTrimFields

Takes one parameter, FieldBaseToTrim

 

KeepFor

Takes two parameters, FromIndex, ToIndex

 

KeepIfAny

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

 

CheckPw$

Takes two parameters, User and Password

 

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

 

Thread

Takes a variable number of parameters

 

Extract$

Takes two parameters, Source, Search

 

JsonStream$

Has one parameter, Options

 

JsonEncode$

Has two parameters: Source, Options

 

ExtractAny$

Takes two parameters, Source , Search

 

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.

 

Export and Import of Database Schema

ExportSchema and ImportSchema are BuiltIn procedures that are available for use with source control systems.

 

Get Started with Setting up the Development Environment

Developing in Moxie.Build on localhost give you the advantage of working with the template files natively. When working on procedures (MOX code) you need to access that through the Procedures page in the Admin area of a Moxie.Build system, if running the server on localhost or on a remote server. When running on a remote server, you can edit the template files via the Files page in the Admin area.

 

AppendQuery

Takes 3 parameters, DestinationQuery, SourceQuery, bMoveIt

 

[Pull] List of Fields from another Query

Takes three parameters, QueryName, FieldBase, FieldNames

 

LookupQuery

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

 

CopyUnique

Takes four parameters, DestinationQuery, SourceQuery, UniqueField, UniqueValue

 

RTrim$

Takes two parameters, Source, Search

 

RetainAny$

Takes two parameters, Source, Search

 

ReplaceAny$

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

 

SessionIsGroupType$

Takes one parameter, a List of possible group types

 

Similar$

Takes 2 parameters, pString1, pString2

 

Similar%

Takes 2 parameters, pNum1, pNum2

 

Setup$

Takes one parameter, Name

 

LTrim$

Takes two parameters, Source, Search

 

LastAny$

Takes two parameters, Source, Search

 

Lang$

Takes one parameter, Source

 

LTrimAny$

Takes two parameters, Source, Search

 

Remove$

Takes two parameters, Source and Search

 

RemainAny$

Takes two parameters, Source and Search

 

Remain$

Takes two parameters, Source and Search