Search Results for match

 

TallyAny$

Takes two parameters, Source, Match

 

TallyAny%

Takes two parameters, Source, Match

 

JoinQuery

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

 

InStrAny$

Takes two parameters, Source, Match

 

InStr%

Takes two parameters, Source, Match

 

InStr$

Takes two parameters, Source, Match

 

InStrAny%

Takes two parameters, Source, Match

 

Tally$

Takes two parameters, Source, Match

 

Tally%

Takes two parameters, Source, Match

 

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

 

Similar%

Takes 2 parameters, pNum1, pNum2

 

Similar$

Takes 2 parameters, pString1, pString2

 

SessionIsGroupType$

Takes one parameter, a List of possible group types

 

Setup$

Takes one parameter, Name

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

AppendTable

Takes one parameter, TableName

 

ChildrenAlias

Takes two parameters, ChildTableName, Mode

 

Children

Takes two parameters, ChildTableName, Mode

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

 

Parse

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

 

MergeRecords

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

 

KeepUnique

Takes one parameter, FieldName

 

LTrimFields

Takes one parameter, FieldBaseToTrim

 

WithGroup

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

 

Lang

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

Text

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

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

SaveJsonFile

Takes two parameters, FileName, Options

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

Update

Takes two parameters, TableName, IfLenFld

 

New

Takes two parameters, TableName, IfLenFld

 

Delete

Takes two parameters, TableName and a boolean expression

 

Detach

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

 

KeepFor

Takes two parameters, FromIndex, ToIndex

 

KeepIfAny

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

 

KeepFields

Takes two parameters, FieldBase, FieldNamesList

 

DeleteFields

Takes two parameters, FieldBase, FieldNameList

 

JsonEmbed

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

 

Thread

Takes a variable number of parameters

 

[Pull] List of Fields from another Query

Takes three parameters, QueryName, FieldBase, FieldNames

 

LookupQuery

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

 

Moxie.cfg Config

The Moxie.cfg file is read on server start and controls aspects that cannot be changed while the server is running.

 

[!] Assert (Top Query)

Parameter is a comma separated list (using CSV rules and not in quotes) of the fixed hard coded values to select from

 

Setup Table

The Setup Table controls aspects that can be changed while the server is running, and is intended to contain both Moxie.Build specific values as well as application specific.

 

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.

 

CopyUnique

Takes four parameters, DestinationQuery, SourceQuery, UniqueField, UniqueValue

 

[!] Limited Selection List (DB Field Attribute)

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.

 

 

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.

 

Export and Import of Database Schema

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

 

Call

Takes a variable number of parameters

 

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.

 

CheckPw$

Takes two parameters, User and Password

 

RemainAny$

Takes two parameters, Source and Search

 

Remain$

Takes two parameters, Source and Search

 

LTrimAny$

Takes two parameters, Source, Search

 

Remove$

Takes two parameters, Source and Search

 

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

 

LTrim$

Takes two parameters, Source, Search

 

Json$

Has two parameters: Source, Name

 

ExtractAny$

Takes two parameters, Source , Search

 

Extract$

Takes two parameters, Source, Search

 

JsonEncode$

Has two parameters: Source, Options

 

LastAny$

Takes two parameters, Source, Search

 

Lang$

Takes one parameter, Source

 

JsonStream$

Has one parameter, Options