Search Results for match

 

InStr%

Takes two parameters, Source, Match

 

Tally%

Takes two parameters, Source, Match

 

InStr$

Takes two parameters, Source, Match

 

InStrAny$

Takes two parameters, Source, Match

 

InStrAny%

Takes two parameters, Source, Match

 

JoinQuery

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

 

TallyAny$

Takes two parameters, Source, Match

 

TallyAny%

Takes two parameters, Source, Match

 

Tally$

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

 

TrimAny$

Takes two parameters, Source, Match

 

ParseCountAny$

Takes two parameters, Source and Match

 

[!] Limited Selection List

Parameter is a comma separated list (without quotes) of the options made available to the user and 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 it 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.

 

Children

Takes two parameters, ChildTableName, Mode

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

Detach

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

 

Delete

Takes two parameters, TableName and a boolean expression

 

Text

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

 

WithGroup

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

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

SaveJsonFile

Takes two parameters, FileName, Options

 

New

Takes two parameters, TableName, IfLenFld

 

LTrimFields

Takes one parameter, FieldBaseToTrim

 

MergeRecords

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

 

KeepUnique

Takes two parameters, WorkFieldBase, UniqueValueField

 

KeepFor

Takes two parameters, FromIndex, ToIndex

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

 

Update

A database command which takes two parameters, TableName, IfLenFld

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

Parse

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

 

JsonStream

Used to manipulate a WorkQuery into a JSON type

 

AppendTable

Takes one parameter, TableName

 

Lang$

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

JsonStream$

Used to manipulate a WorkQuery into a JSON type

 

LTrim$

Takes two parameters, Source, Search

 

LastAny$

Takes two parameters, Source , Search

 

ExtractAny$

Takes two parameters, Source , Search

 

LookupQuery

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

 

AppendQuery

Takes 3 parameters, DestinationQuery, SourceQuery, bMoveIt

 

CheckPw$

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

 

[Pull] List of Fields from another Query

Takes up to three parameters, QueryName, FieldBase, FieldNames

 

Setup$

Takes one parameter, Name

 

RTrim$

Takes two parameters, Source, Search

 

Similar$

Takes 2 parameters, pString1, pString2

 

Similar%

Takes 2 parameters, pNum1, pNum2

 

RetainAny$

Takes two parameters, Source, Search

 

Remain$

Takes two parameters, Source and Search

 

LTrimAny$

Takes two parameters, Source, Search

 

Remove$

Takes two parameters, Source and Search

 

RemainAny$

Takes two parameters, Source and Search