Complete List, MOX Keywords

 

Abs%

Has one parameter, a numeric value.

Read more...

 

AjaxReply

Has no parameters

Read more...

 

AmPm$

Takes one parameter

Read more...

 

AnsiToUtf16$

Has one parameter.

Read more...

 

AnsiToUtf8$

Has one parameter.

Read more...

 

AntiCsrf$

Has no params

Read more...

 

AppendQuery

Takes 3 parameters, DestinationQuery, SourceQuery, bMoveIt

Read more...

 

AppendTable

Takes one parameter, TableName

Read more...

 

ApplyLang$

Takes one parameter

Read more...

 

ATn%

Takes one parameter

Read more...

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

Read more...

 

Backfill

Has no parameters

Read more...

 

Bin$

Takes one parameter

Read more...

 

Build

Takes a variable number of parameters

Read more...

 

Call

Takes a variable number of parameters

Read more...

 

CFApi$

Takes three parameters Method, URL, Body

Read more...

 

CFPurge

Takes one parameter, the URL to purge from CloudFlare's cache

Read more...

 

CheckPw$

Takes two parameters, User and Password

Read more...

 

Children

Takes two parameters, ChildTableName, Mode

Read more...

 

ChildrenAlias

Takes two parameters, ChildTableName, Mode

Read more...

 

Chr$

Takes one parameter

Read more...

 

Compress$

Compress any value/table

Read more...

 

Const

Takes two parameters, the variable name and a value

Read more...

 

CopyFields

Takes two parameters, DestinationFields, SourceFields

Read more...

 

CopyFirst

Takes two parameters, DestinationQuery, SourceQuery

Read more...

 

CopyQuery

Takes two parameters, destinationQuery, sourceQuery

Read more...

 

CopyTable

Takes four parameters, DestinationTable, SourceTable, bWithParents, bWithPWHashes

Read more...

 

CopyUnique

Takes four parameters, DestinationQuery, SourceQuery, UniqueField, UniqueValue

Read more...

 

Cos%

Takes one parameter

Read more...

 

Critical

Takes one parameter, the Name of the critical section

Read more...

 

CsvStream

Takes two parameters, CSVData, bNoHeaders

Read more...

 

CsvStream$

Takes one parameter bNoHeaders and returns the result to an assigned variable

Read more...

 

Ctid$

Has no params

Read more...

 

Cuid$

Has no params

Read more...

 

Currency$

Takes one parameter, a numeric value

Read more...

 

Date$

Takes one parameter, a string containing a date time

Read more...

 

DateAmPm$

Takes one parameter, a string containing a date and time

Read more...

 

DateTime$

Takes one parameter, a string containing a date and time

Read more...

 

Day$

Takes one parameter, a date

Read more...

 

DayOfWeek$

Takes one parameter, a date

Read more...

 

Decrypt$

Takes two parameters, an encrypted value and the decryption key

Read more...

 

Delete

Takes two parameters, TableName and a boolean expression

Read more...

 

DeleteFields

Takes two parameters, FieldBase, FieldNameList

Read more...

 

DeleteQuery

Takes one parameter, the name of the query

Read more...

 

DeleteTable

Takes one parameter, TableName

Read more...

 

DeleteTableField

Takes two parameters, a TableName and FieldName

Read more...

 

DeleteTableProc

Takes two parameters, a TableName and ProcName

Read more...

 

DeleteTableRltn

Takes two parameters, a TableName1 and TableName2

Read more...

 

Detach

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

Read more...

 

DetachWithDelete

Takes 4 parameters, TableName, Relation, OtherTableName, and a boolean expression (optional)

Read more...

 

Dir$

Takes one parameter, a path-mask

Read more...

 

Discard

Has no parameters

Read more...

 

DnsIp$

Takes one parameter, a domain name

Read more...

 

DnsName$

Takes one parameter, an IPv4 Address

Read more...

 

EmailErr

Takes two parameters, SubjectPrefix, EmailBody

Read more...

 

EmptyTable

Takes one parameter, the name of a database table

Read more...

 

Encrypt$

Takes two parameters, SourceValue, EncryptionKey

Read more...

 

EndSession

Has no parameters.

Read more...

 

EnsureFields

Takes two parameters, FieldBase, FieldNames

Read more...

 

EnsureNavFields

Takes two parameters, FieldBase, FieldNamesList

Read more...

 

Error

Takes one parameter, the text of the error to throw.

Read more...

 

ETableReply

Takes 2 parameters, Result, Status

Read more...

 

ETableStream

Takes two parameters, ExcelTableData, Options

Read more...

 

Exception

Takes one parameter, the text of the exception to throw.

Read more...

 

Exists$

Takes two parameters, DBTableName, DBTableRecordAlias

Read more...

 

Exit (Proc)

Takes no parameters

Read more...

 

Exp%

Takes one parameter, an ExponentValue

 

Exp10%

Has one parameter, any numeric value.

Read more...

 

Exp2%

Takes one parameter, any numeric value.

Read more...

 

Extract$

Takes two parameters, Source, Search

Read more...

 

ExtractAny$

Takes two parameters, Source , Search 

Read more...

 

FailIfRecError

Has no parameters

Read more...

 

FieldDef$

Takes one parameter, FieldName

Read more...

 

File

Takes 3 parameters, Destination, Action, Source

Read more...

 

FileExists$

Takes one parameter, the path where the file is located.

Read more...

 

Files

Takes 5 parameters, FieldBase, Destination, Action, Source, IfLenFld

Read more...

 

FileSize$

Takes one parameter, a value in number of bytes.

Read more...

 

FirstAlias$

Takes one parameter, TableName

Read more...

 

FixFields

Takes one parameter, a single character

Read more...

 

Flush

Takes one parameter, TableName

Read more...

 

FlushAll

Has no parameters

Read more...

 

Folder

Takes two parameters, FolderPath, Action

Read more...

 

FolderExists$

Takes one parameter, the path of the folder

Read more...

 

Folders

Takes a single variable, the relative path to the directory from root of project

Read more...

 

ForEach

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

Read more...

 

Foreign

Takes a single parameter, a QueryName

Read more...

 

ForeignWith

Takes a single parameter, a FieldBase

Read more...

 

Format

Takes five parameters, FieldBase, FieldList, Mask, bBlanks2Zero, IfLenFld

Read more...

 

Format$

Takes two parameters, a source value, and a formatting mask.

Read more...

 

Function

A special type of Private Method, called a Private Function, that is intended to return a single value or multiple values simultaneously.

Read more...

 

Geo

Takes nine parameters, FieldBase, Destination, Function, Source1, Source2, Source3, Source4, Options, IfLenFld

Read more...

 

GeoDistance$

Takes five parameters, Lat1, Long1, Lat2, Long2, Options

Read more...

 

Get

Takes two parameters, TableName, IfLenFld

Read more...

 

GetFieldDefs

Has no parameters.

Read more...

 

GoTo

Takes one parameter, a Label

Read more...

 

Greg$

Takes one parameter, a gregorian number

Read more...

 

Greg%

Takes one parameter, a date of the form yyyy-mm-dd

Read more...

 

Group

Takes 7 parameters, FieldBase, GroupBy, GroupTotals, GrandTotals, Seperator, TotalPre, TotalPost

Read more...

 

Guid$

Takes no parameters

Read more...

 

Hash$

Takes one parameter, a source value

Read more...

 

Hex$

Takes one parameter, a source value

Read more...

 

Html

Takes 3 parameters, Location, Mode, Text

Read more...

 

HtmlAButton

Takes 6 parameters, Location, Mode, ActionLabel, ActionPath, Class, Extra.

Read more...

 

HtmlAlert

Takes three parameters, Location, ClassNames, AlertText

Read more...

 

HtmlButton

Takes 6 parameters, Location, Mode, ActionLabel, ActionPath, Class, ActionMethod

Read more...

 

HtmlDropdown

Takes 5 parameters, Location, Mode, Title, Element, Class

Read more...

 

HtmlDTable

Takes 5 parameters, Location, Mode, Class/ID, Init, bNoAutoAlign

Read more...

 

HtmlErr

Takes one parameter, ErrMsg

Read more...

 

HtmlETable

Takes 6 parameters, Location, Mode, Div, Data, Script, Extra

Read more...

 

HtmlForm

Takes 6 parameters, Location, Mode, ActionLabel, ActionPath, Class, ActionMethod

Read more...

 

HtmlHistory

Takes two parameters, Title, Path

Read more...

 

HtmlJButton

Takes 6 parameters, Location, Mode, ActionLabel, ActionScript, Class, Extra.

Read more...

 

HtmlNav

Takes 7 parameters, Location, Mode, Title, TitleLink, Class, HtmlPre, HtmlApn

Read more...

 

HtmlNavbar

Takes 10 parameters, Location, Mode, Title, TitleLink, Class, Fixed, bUseContainer, bNotResponsive, bInverted, HtmlPre, HtmlApn

Read more...

 

HtmlPageBreak

Takes two parameters, Location, Mode

Read more...

 

HtmlRaw

Takes 3 parameters, Location, Mode, bWithNoHeader

Read more...

 

HtmlReset

Has no parameters

Read more...

 

HtmlSearchBox

Takes 6 parameters, Location, Mode, ActionPath, Name, Class, Prompt

Read more...

 

HtmlTab

Takes 3 parameters, Location, Mode, bWithNoHeader

Read more...

 

HtmlTable

Takes 6 parameters, Location, Mode, Class, bNoHeader, bNoAutoAlign, bNoIDTags

Read more...

 

HtmlToText$

Takes a single parameter, Source

Read more...

 

HtmlUpload

Takes seven parameters, Location, Mode, Prompt, Path, Class, Name, HelpText

Read more...

 

Http$

Takes 9 parameters, ServerName, Port, bSecure, Mode, Path, ContentType, extraHeader, body, rtnHeaders

Read more...

 

HttpCookie

Takes 6 parameters, Name, Value, Path, Domain, Expires, Other

Read more...

 

HttpHeader

Takes two parameters, name, value

Read more...

 

HttpHeader$

Has one parameter

Read more...

 

HttpHeaders$

Has no parameters

Read more...

 

HttpNoCache

Has no parameters.

Read more...

 

HttpsEnsure

Takes no parameters.

Read more...

 

HttpSoap$

Takes 8 parameters, ServerName, Port, bSecure, Path, ExtraHttpHeaders, Envelope, ExtraBody, xml

Read more...

 

HttpStatus

Takes one parameter, Status

Read more...

 

HttpType

Takes one parameter, Type

Read more...

 

If (Not) / And / Or / ElseIf / End If

Takes a variable number of conditional statements

Read more...

 

If (Not) / Then

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

Read more...

 

Image

Has 5 parameters, DestFileName, Action, SrcFileName, Val1, Val2

Read more...

 

Images

Takes up to 6 parameters, FieldBase, FileName, Action, Val1, Val2, IfLenField

Read more...

 

Include

Takes one parameter, ProcedureName

Read more...

 

IncrKillCount

Has one parameter.

Read more...

 

 

InStr$

Takes two parameters, Source, Match

Read more...

 

InStr%

Takes two parameters, Source, Match

Read more...

 

InStrAny$

Takes two parameters, Source, Match

Read more...

 

InStrAny%

Takes two parameters, Source, Match

Read more...

 

IsGroupType$

Takes two parameters: Username, GroupTypes

Read more...

 

IsValidAlias$

Takes one parameter, a Source value

 

Read more...

 

IsValidDBField$

Takes one parameter, a Source value

Read more...

 

IsValidTable$

Takes one parameter, a Source value

Read more...

 

JoinQuery

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

Read more...

 

Json$

Has two parameters: Source, Name

Read more...

 

JsonDecode$

Has two parameters: Source, Options

Read more...

 

JsonEmbed

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

Read more...

 

JsonEncode$

Has two parameters: Source, Options

Read more...

 

JsonReply

Has no parameters

Read more...

 

JsonStream

Takes two parameters, Data, Options

Read more...

 

JsonStream$

Has one parameter, Options

Read more...

 

KeepFields

Takes two parameters, FieldBase, FieldNamesList

Read more...

 

KeepFirst

Takes no parameters

Read more...

 

KeepFor

Takes two parameters, FromIndex, ToIndex

Read more...

 

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

Read more...

 

KeepIfAll

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

Read more...

 

KeepIfAny

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

Read more...

 

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

Read more...

 

KeepIfSimilar

Takes 3 parameters, FieldBase, pOne, pTwo

Read more...

 

KeepLast

Takes no parameters

Read more...

 

KeepNone

Takes no parameters

Read more...

 

KeepUnique

Takes one parameter, FieldName

Read more...

 

Keywords$

Has one parameter.

Read more...

 

Lang

Takes four parameters, FieldBase, Destination, Source, IfLenFld

Read more...

 

Lang$

Takes one parameter, Source

Read more...

 

LangWith

Has one parameter, a Content.Lang prefix

Read more...

 

Last$

Takes two parameters, Source , Search 

Read more...

 

LastAlias$

Takes one parameter, TableName

Read more...

 

LastAny$

Takes two parameters, Source, Search 

Read more...

 

LCase$

Takes a single Source parameter

Read more...

 

Left$

Takes two parameters, Source, Value

Read more...

 

Len$

Takes one parameter, a Source value

Read more...

 

Len%

Takes one parameter, a Source value

Read more...

 

LFillFields

Takes one parameter, a FieldBase

Read more...

 

ListFields

Takes one parameter, TableName

Read more...

 

ListFiles

Takes 3 parameters, Folder, Filter, bShowImgSize

Read more...

 

ListFolders

Takes two parameters, FolderPath, bRecursive

Read more...

 

ListProcs

Takes one parameter, TableName

Read more...

 

ListQueries

Takes no parameters

Read more...

 

ListRltns

Takes one parameter, TableName

Read more...

 

ListTables

Has no parameters

Read more...

 

LoadCsvFile

Takes two parameters, FileName, bHasHeader

Read more...

 

LoadFile$

Takes one parameter, PathToFile

Read more...

 

LoadJsonFile

Takes two parameters, PathToFile, Options

Read more...

 

LoadMemUsage

Has no parameters

Read more...

 

LoadNulFile

Takes two parameters, FileName, bHasHeader

Read more...

 

LoadRawFile

Takes one parameter, FilePath

Read more...

 

LoadRecord

Takes two parameters, TableName, RecordAlias

Read more...

 

LoadTabFile

Takes two parameters, FileName, bHasHeader

Read more...

 

LoadTable

Takes one parameter, TableName

Read more...

 

LoadTableFields

Takes one parameter, TableName

Read more...

 

LoadTableFiles

Takes one parameter, TableName

Read more...

 

Log%

Takes one parameter, Source value

Read more...

 

Log10%

Takes one parameter, a Source value

Read more...

 

Log2%

Takes one parameter, a Source value

Read more...

 

Login

Takes three parameters, Login, Password, bRememberMe

Read more...

 

Login$

Takes three parameters, Login, Password, bRememberMe

Read more...

 

Logout

Takes one parameter, SessionID

Read more...

 

LongDate$

Takes one parameter, a Date value

Read more...

 

Lookup

Takes six parameters, FieldBase, Destination, Table, Alias, SourceField, IfLenFld

Read more...

 

Lookup$

Takes one parameter, in the form of: Table|{Alias}|Field

Read more...

 

LookupQuery

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

Read more...

 

LTrim$

Takes two parameters, Source, Search

Read more...

 

LTrimAny$

Takes two parameters, Source, Search

Read more...

 

LTrimFields

Takes one parameter, FieldBaseToTrim

Read more...

 

Macro

A set of instructions that can be called with parameters to run in the current scope.

Read more...

 

MakeValidAlias$

Takes one parameter, a Source value

Read more...

 

MakeValidDBField$

Takes one parameter, Source value

Read more...

 

MakeValidTable$

Takes one parameter, Source

Read more...

 

MapQuery

Takes five parameters, DestQuery, SourceQuery, SourceXFld, SourceYFld, SourceZFld

Read more...

 

 

Math

Takes a variable number of parameters

Read more...

 

MCase$

Takes one parameter, Source

Read more...

 

MergeFields

Takes 4 parameters, FieldBase, Destination, SourceFields, Delimiter

Read more...

 

MergeRecords

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

Read more...

 

Meta

Takes any unspecified data, intended for use by external systems

Read more...

 

Method

Private Method contained within a given procedure.

Read more...

 

Month$

Takes one parameter, Source

Read more...

 

MoveQuery

Takes two parameters, DestinationQuery, SourceQuery

Read more...

 

MsgBox

Takes two parameters, Text, Title

Read more...

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

Read more...

 

NamesToLabels

Takes no parameters

Read more...

 

NbSp$

Takes no parameters

Read more...

 

New

Takes two parameters, TableName, IfLenFld

Read more...

 

NewEComQuery

Takes one parameter, QueryName

Read more...

 

NewFields

Takes two parameters, FieldBase, FieldNames

Read more...

 

NewQuery

Takes 3 parameters, QueryName, SourceQuery, bWork

Read more...

 

NewRecords

Takes one parameter, QuantityToAdd

Read more...

 

NewTable

Takes two parameters, TableName, AutoAlias

Read more...

 

NewTableField

Takes six parameters, TableName, FieldName, Label, Note, Attr, DevNote

Read more...

 

NewTableProc

Takes nine parameters, TableName, ProcName, Type, Params, GroupTypes, Label, Note, DevNote, Source

Read more...

 

NewTableRltn

Takes seven parameters, TableName, OtherTableName, ParentChild, Ratio, Note, Attr, DevNote

Read more...

 

NewWithAttach

Takes 4 parameters, TableName, Relation, OtherTableName, IfLenFld

Read more...

 

NoKillCount

Takes no parameters

Read more...

 

NulStream

Takes two parameters, Data, bHasHeader

Read more...

 

NulStream$

Takes one parameter, bNoHeader

Read more...

 

Num

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

Read more...

 

Offset

Takes 7 parameters, FieldBase, Destination, Source, OffsetVal, Operator, OpValue, IfLenFld

Read more...

 

OnError (Continue)

Used as a scoping keyword, similar to WorkWith/End WorkWith.

Read more...

 

PaaS

Takes three parameters, Url, SaaSTenant, InputQuery, OutputQuery

Read more...

 

Parents

Takes three parameters, ChildTableName, ParentTableName, Mode

Read more...

 

ParentsAlias

Takes three parameters, ChildTableName, ParentTableName, Mode

Read more...

 

Parse

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

Read more...

 

Parse$

Takes four parameters, Source, bAny, Search, Item

Read more...

 

ParseCount$

Takes two parameters, Source and Match

Read more...

 

ParseCount%

Takes two parameters, Source and Match

Read more...

 

ParseCountAny$

Takes two parameters, Source and Match

Read more...

 

ParseCountAny%

Takes two parameters, Source and Match

Read more...

 

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

Read more...

 

Path$

Takes one parameter, Index

Read more...

 

PickFirstField

Takes three parameters, FieldBase, Destination, SourceFields

Read more...

 

Pivot

Takes two parameters, FieldBase, PivotField

Read more...

 

Plus8Decode

Takes three parameters, FieldBase, Fields, IfLenFld

Read more...

 

Plus8Decode$

Takes one parameter, Source

Read more...

 

Plus8Encode

Takes three parameters, FieldBase, Fields, IfLenFld

Read more...

 

Plus8Encode$

Takes one parameter, Source

Read more...

 

Prefix

Takes a single string as parameter, which is then appended to each line in the code block.

Read more...

 

ProcECom

Takes one parameter, QueryName

Read more...

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

Read more...

 

PWHash

Takes three parameters, TableName, Alias, Password

Read more...

 

PWHash$

Takes three parameters, TableName, Alias, Password

Read more...

 

QBox

Takes two parameters, QueryName, Title

Read more...

 

Raw

Takes one parameter, the contents of which are used for the HTTP Reply Body

Read more...

 

RawStream$

Takes one parameter, a top query destination variable

Read more...

 

RecoverHtml$

Takes one parameter, EscapedHTMLString, and returns the Unescaped Version of this string

Read more...

 

RecoverHtmlObj$

Takes one parameter, EscapedHTMLString, and returns the Unescaped Version of this string

Read more...

 

RecoverMOX$

Takes one parameter, HtmlEscapedString, and returns the Unescaped Version of this string

Read more...

 

RecoverTmpl$

Takes one parameter, EscapedTemplate, and returns the Unescaped Version of this string

Read more...

 

Rem / EndRem

A type of Prefix which allows the developer to separate blocks of code into organized, defined parts to help provide clarity of the logical block and add structure to the code.

Read more...

 

Remain$

Takes two parameters, Source and Search

Read more...

 

RemainAny$

Takes two parameters, Source and Search

Read more...

 

Remote

Takes three parameters, Url, InputQuery, OutputQuery

Read more...

 

Remove$

Takes two parameters, Source and Search

Read more...

 

RemoveAny$

Takes two parameters, Source and Search

Read more...

 

ReorderTableFields

Takes two parameters, TableName, FieldList

Read more...

 

ReorderTableProcs

Takes two parameters, TableName, ProcList

Read more...

 

ReorderTableRltns

Takes two parameters, TableName, RltnList

Read more...

 

Repeat$

Takes two parameters, Source, Count

Read more...

 

Replace$

Takes one existing Source value, and two parameters, Search, NewVal

Read more...

 

ReplaceAny$

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

Read more...

 

Reset

Takes no parameters.

Read more...

 

ResetFields

Takes two parameters, FieldBase, FieldNames

Read more...

 

ResetTableNextAlias

Takes one parameter, TableName

Read more...

 

RetainAny$

Takes two parameters, Source, Search

Read more...

 

Return

Takes a variable number of parameters.

Read more...

 

Reverse$

Takes one parameter, Source

Read more...

 

Right$

Takes two parameters, Source, Value

Read more...

 

Rnd%

Takes two parameters, Low, High

Read more...

 

RTrim$

Takes two parameters, Source, Search

Read more...

 

RTrimAny$

Takes two parameters, Source, Search

Read more...

 

SaveCsvFile

Takes two parameters, FilePath, bUseHeader

Read more...

 

SaveFile

Takes two parameters, FileName, FileData

Read more...

 

SaveHttpFile

Takes two parameters, FileName, URL

Read more...

 

SaveJsonFile

Takes two parameters, FileName, Options

Read more...

 

SaveNulFile

Takes two parameters, FileName, bUseHeader

Read more...

 

SaveRawFile

Takes two parameters, FileName, bUseHeaders

Read more...

 

SaveTabFile

Takes two parameters, FileName, bUseHeader

Read more...

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

Read more...

 

Select / Case / End Select

Takes a variable number of conditional statements to compare against a single source

Read more...

 

SendEmail

Takes 10 parameters, FieldBase, From, To, Subject, Body, bMerge, AttachName, AttachPath, Slow, IfLenFld

Read more...

 

ServerLog

Takes one parameter, ServerLogText

Read more...

 

Session

Takes two parameters, Name, Value

Read more...

 

Session$

Takes one parameter, Name

Read more...

 

SessionIsGroupType$

Takes one parameter, a List of possible group types

Read more...

 

Set

Takes four parameters, FieldBase, Destination, Source, IfLenFld

Read more...

 

SetEnsure

Takes two parameters, FieldName, Value

Read more...

 

SetFirst

Takes four parameters, FieldBase, Destination, Source, IfLenFld

Read more...

 

SetIf

Takes six parameters, FieldBase, Destination, Source, Left, Comparison, Right

Read more...

 

SetIfAll

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

Read more...

 

SetIfAny

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

Read more...

 

SetKillCount

Takes one parameter, Value

Read more...

 

SetLast

Takes four parameters, FieldBase, Destination, Source, IfLenFld

Read more...

 

SetNew

Takes four parameters, FieldBase, FieldName, Source, IfLenFld

Read more...

 

Setup

Takes two parameters, Name, Value

Read more...

 

Setup$

Takes one parameter, Name

Read more...

 

Sgn%

Takes one parameter, Value

Read more...

 

Similar$

Takes 2 parameters, pString1, pString2

Read more...

 

Similar%

Takes 2 parameters, pNum1, pNum2

Read more...

 

Sin%

Takes one parameter, Value

Read more...

 

SkipCalls

Takes no parameters

Read more...

 

Sleep

Takes one parameter.

Read more...

 

Sort

Takes two parameters, FieldBase, SortFieldList

Read more...

 

Sqr%

Takes one parameter, Value

Read more...

 

SSColAlpha$

Takes one parameter, Source

Read more...

 

SSColNum$

Takes one parameter, Source

Read more...

 

SSReference

A command to help build spreadsheets

Read more...

 

TabStream

Takes two parameters, Data, bHasHeader

Read more...

 

TabStream$

Takes one parameter, bNoHeaders

Read more...

 

Tally$

Takes two parameters, Source, Match

Read more...

 

Tally%

Takes two parameters, Source, Match

Read more...

 

TallyAny$

Takes two parameters, Source, Match

Read more...

 

TallyAny%

Takes two parameters, Source, Match

Read more...

 

Tan%

Takes one parameter, Value

Read more...

 

Tcp$

Takes three parameters, ServerName, Port, bSecure, Send

Read more...

 

TemplateCustom

Takes one parameter, TemplateData

Read more...

 

TemplateName

Takes one parameter, Name

Read more...

 

TemplateRuntime

Takes one parameter, Name

Read more...

 

TemplateType

Takes one parameter, Type

Read more...

 

Text

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

Read more...

 

TextToHtml$

Takes one parameter, Source

Read more...

 

Thread

Takes a variable number of parameters

Read more...

 

Time

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

Read more...

 

Time$

Takes one parameter, Source

Read more...

 

TimeAdd$

Takes two parameters, Source, Value

Read more...

 

TimeDif$

Takes two parameters, Source, Value

Read more...

 

TimeSub$

Takes two parameters, Source, Value

Read more...

 

TimeZone$

Takes two parameters, Source, Value

Read more...

 

TopField

Takes one parameter, FieldName

Read more...

 

TopQuery

Takes one parameter, FieldBase

Read more...

 

TopWith

Takes one parameter, FieldBase

Read more...

 

Trigger

Takes two parameter, URL, InputQuery

Read more...

 

Trim$

Takes two parameters, Source, Search

Read more...

 

TrimAny$

Takes two parameters, Source, Match

Read more...

 

TRON

Takes one parameter, FilePath

Read more...

 

TRONLog

Takes one parameter, OutputText

Read more...

 

Truncate$

Takes two parameters, Source, MinLength

Read more...

 

Try / Catch / Finally / End Try

A traditional way to check for hard errors and enable those errors to error softly.

Read more...

 

UCase$

Takes one parameter, Source

Read more...

 

 

UnloadTableFiles

Takes one parameter, TableName

Read more...

 

Update

Takes two parameters, TableName, IfLenFld

Read more...

 

UpdateOrNew

Takes two parameters, TableName, IfLenFld

Read more...

 

UpdateOrNewWithAttach

Takes four parameters, TableName, Relation, OtherTableName, IfLenFld

Read more...

 

UpdateTableField

Takes seven parameters, TableName, OldFieldName, NewFieldName, Label, Note, Attr, DevNote

Read more...

 

UpdateTableProc

Takes ten parameters, TableName, OldProcName, NewProcName, Type, Params, GroupTypes, Label, Note, DevNote, Source

Read more...

 

UpdateTableRltn

Takes eight parameters, TableName, OldOtherTableName, NewOtherTableName, ParentChild, Ratio, Note, Attr, DevNote

Read more...

 

UrlDecode$

Takes one parameter, Source

Read more...

 

UrlEncode$

Takes one parameter, Source

Read more...

 

Utf16ToAnsi$

Takes one parameter, Source

Read more...

 

Utf16ToUtf8$

Takes one parameter, Source

Read more...

 

Utf8ToAnsi$

Takes one parameter, Source

Read more...

 

Utf8ToUtf16$

Takes one parameter, Source

Read more...

 

ValidDate$

Takes one parameter, a Source value.

Read more...

 

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

Read more...

 

Verify$

Takes two parameters, Source, AllowedCharacters (case sensitive)

Read more...

 

Verify%

Takes two parameters, Source, AllowedCharacters (case sensitive)

Read more...

 

WebSafe$

Takes one parameter, Source

Read more...

 

WithAll

Takes five parameters, FieldBase, Destination, Action, Source, IfLenFld

Read more...

 

WithGroup

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

Read more...

 

WorkIf

Takes one parameter, FieldName

Read more...

 

WorkQuery

Takes one parameter, QueryName

Read more...

 

WorkWith

Takes one parameter, FieldBase

Read more...

 

XmlMerge

Takes two parameters, [WorkWith]+Scope, EmbedScope

Read more...

 

XmlStream

Takes one parameter, Data

Read more...

 

Year$

Takes one parameter, Source

Read more...

 

[ ? ] Pick First (Top Query)

Parameter is a space separated list of fields to choose from

Read more...

 

[#] Format (Top Query)

Takes 1 parameter, a formatting mask

Read more...

 

[$] Currency (Top Query)

Takes one parameter, Source

Read more...

 

[AnyRecError]

Takes no parameters.

Read more...

 

[CountIf]

Takes one parameter, TestCondition

Read more...

 

 

 

[Ensure] Field Exists

Takes a variable number of parameters, a comma separated list of TopQuery variable names

Read more...

 

[HtmlOutput]

Takes a variable number of parameters

Read more...

 

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

Read more...

 

 

[Meta]

Takes no parameters

Read more...

 

[Me]

Takes no parameters

Read more...

 

[New] Field

Takes one parameter, a comma separated list of FieldNames

Read more...

 

[Pull] List of Fields from another Query

Takes three parameters, QueryName, FieldBase, FieldNames

Read more...

 

 

[TemplateName]

Takes no parameters

Read more...

 

[TemplateType]

Takes no parameters

Read more...

 

 

[TQFieldList]

Takes no parameters

Read more...

 

[TQFldCount]

Takes no parameters

Read more...

 

[TQMessage]

Takes one parameter, Message, or no parameters

Read more...

 

[TQName]

Has no parameters

Read more...

 

[TQRecCount]

Has no parameters

Read more...

 

[TQResult]

Takes either one parameter, ResultValue, or no parameters

Read more...

 

[WQFieldList]

Has no parameters

Read more...

 

[WQFldCount]

Takes no parameters

Read more...

 

[WQMessage]

Takes one parameter, Message, or no parameters

Read more...

 

[WQName]

Has no parameters

Read more...

 

[WQRecCount]

Has no parameters

Read more...

 

[WQResult]

Takes either one parameter, ResultValue, or no parameters

Read more...

 

[_#] Format if not blank (Top Query)

Takes 1 parameter, a formatting mask

Read more...

 

[_$] Currency if not blank (Top Query)

Has no parameters. If the field is blank it will remain blank.

Read more...