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

 

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

 

CFApi$

Takes one parameter, a string parameter of the desired API command

Read more...

 

CFPurge

Takes one parameter, the string URL to send to CloudFlare's API

Read more...

 

CheckPw$

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

Read more...

 

Children

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 two parameters, destinationTable, sourceTable

Read more...

 

Cos%

Takes one parameter

Read more...

 

Critical

Takes one parameter, the Name of the critical section

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

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

 

DeleteTableField

Takes two parameters, a FieldBase and FieldNamesList

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

The email address that will receive any run time errors that a website encounters

Read more...

 

EmptyTable

Takes one parameter, the name of a database table

Read more...

 

Encrypt$

Takes two parameters, SourceValue, EncryptionKey

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

 

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 value, Search value

Read more...

 

ExtractAny$

Takes two parameters, Source value, Search value

Read more...

 

FailIfRecError

Has no parameters

Read more...

 

FieldDef$

Takes a single parameter, in the format of TableName.FieldName#Deff where Deff is one of: Label, Attr, Note, or DevNote

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

 

 

 

Folder

Takes one parameter, the path of the folder

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, is intended to return a single value or multiple values simultaneously.

Read more...

 

Get

Takes one parameter, a TableName

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, ActionPath, 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, 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...

 

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 variable number of conditional statements

Read more...

 

Image

Has 4 parameters, FileName, Action, 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...

 

 

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

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

Read more...

 

JsonStream

Used to manipulate a WorkQuery into a JSON type

Read more...

 

JsonStream$

Used to manipulate a WorkQuery into a JSON type

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 two parameters, WorkFieldBase, UniqueValueField

Read more...

 

 

 

Lang$

Takes four parameters, FieldBase, Destination, Source, IfLenFld

Read more...

 

 

 

LastAlias$

Takes one parameter, TableName

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

 

ListFiles

Takes 3 parameters, Folder, Filter, bShowImgSize

Read more...

 

ListFolders

Takes two parameters, Folder, Filter

Read more...

 

ListQueries

Takes no parameters

Read more...

 

 

LoadFile$

Takes one parameter, PathToFile

Read more...

 

LoadJsonFile

Takes one parameter, PathToFile

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

 

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

 

 

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

 

 

 

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

 

 

 

 

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

 

Parents

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

 

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

 

 

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

 

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

 

 

RecoverHtml$

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

Read more...

 

 

 

 

 

Rem / EndRem

A type of Prefix which allows the programmer to create Remarks or Comments in their 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...

 

 

 

Repeat$

Takes two parameters, Source, Count

Read more...

 

Replace$

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

Read more...

 

 

Reset

Takes no parameters.

Read more...

 

ResetFields

Takes two parameters, FieldBase, FieldNames

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 one parameter, FilePath

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, bUseHeaders

Read more...

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

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 two parameters, FieldName, FieldValue

Read more...

 

Setup

Takes two parameters, Name, Value

Read more...

 

Setup$

Takes one parameter, Name

Read more...

 

Sgn%

Takes one parameter, Value

Read more...

 

 

 

Sin%

Takes one parameter, Value

Read more...

 

SkipCalls

Takes no parameters

Read more...

 

 

Sort

Takes two parameters, FieldBase, SortFieldList

Read more...

 

Sqr%

Takes one parameter, Value

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

 

 

Time$

Takes one parameter, Source

Read more...

 

TopField

Takes one parameter, FieldName

Read more...

 

TopQuery

Takes one parameter, FieldBase

Read more...

 

TopWith

Takes one parameter, FieldBase

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

 

 

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

A database command which takes two parameters, TableName, IfLenFld

Read more...

 

UpdateOrNew

A database command which takes two parameters, TableName, IfLenFld

Read more...

 

UpdateOrNewWithAttach

A database command which takes four parameters, TableName, Relation, OtherTableName, IfLenFld

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

 

 

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

 

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

 

[L] Lookup (Top Query)

Parameter is the database path that is to be looked up in the form of TableName|Alias|FieldName where it may be a specific fixed path or you may use {} to replace one or more of the path components where the value inside the {} is a field name in the current record.

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 up to three parameters, QueryName (optional), FieldBase (optional), a list of comma separated FieldNames that may or may not exist in the QueryName.

Read more...

 

[Reset] Fields

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