Abs%

Has one parameter, a numeric value.

AjaxReply

Has no parameters

AmPm$

Takes one parameter

AnsiToUtf16$

Has one parameter.

AnsiToUtf8$

Has one parameter.

AntiCsrf$

Has no params

AppendQuery

Takes 3 parameters, DestinationQuery, SourceQuery, bMoveIt

AppendTable

Takes one parameter, TableName

ApplyLang$

Takes one parameter

Asc$

Takes two parameters, SourceValue, Position

ATn%

Takes one parameter

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

Backfill

Has no parameters

Bin$

Takes two parameters, SourceValue, Width

Bom$

Takes one parameter

BomToUtf8$

Takes one parameter

Build

Takes a variable number of parameters

Call

Takes a variable number of parameters

CFApi$

Takes three parameters Method, URL, Body

CFPurge

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

CheckPw$

Takes two parameters, User and Password

Children

Takes two parameters, ChildTableName, Mode

ChildrenAlias

Takes two parameters, ChildTableName, Mode

Chr$

Takes one parameter

Compress$

Compress any value/table

Const

Takes two parameters, the variable name and a value

CopyFields

Takes two parameters, DestinationFields, SourceFields

CopyFirst

Takes two parameters, DestinationQuery, SourceQuery

CopyQuery

Takes two parameters, destinationQuery, sourceQuery

CopyTable

Takes four parameters, DestinationTable, SourceTable, bWithParents, bWithPWHashes

CopyUnique

Takes four parameters, DestinationQuery, SourceQuery, UniqueField, UniqueValue

Cos%

Takes one parameter

Critical

Takes one parameter, the Name of the critical section

CsvStream

Takes two parameters, CSVData, bNoHeaders

CsvStream$

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

CsvStreamWS

Takes two parameters, CSVData, bNoHeaders

Ctid$

Has one parameter.

Cuid$

Has no params

Currency$

Takes one parameter, a numeric value

Date$

Takes one parameter, a string containing a date time

DateAmPm$

Takes one parameter, a string containing a date and time

DateTime$

Takes one parameter, a string containing a date and time

Day$

Takes one parameter, a date

DayOfWeek$

Takes one parameter, a date

Decrypt$

Takes two parameters, an encrypted value and the decryption key

Delete

Takes two parameters, TableName and a boolean expression

DeleteFields

Takes two parameters, FieldBase, FieldNameList

DeleteQuery

Takes one parameter, the name of the query

DeleteTable

Takes one parameter, TableName

DeleteTableField

Takes two parameters, a TableName and FieldName

DeleteTableProc

Takes two parameters, a TableName and ProcName

DeleteTableRltn

Takes two parameters, a TableName1 and TableName2

Detach

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

DetachWithDelete

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

Dir$

Takes one parameter, a path-mask

Discard

Has no parameters

DnsIp$

Takes one parameter, a domain name

DnsName$

Takes one parameter, an IPv4 Address

EmailErr

Takes two parameters, SubjectPrefix, EmailBody

EmptyTable

Takes one parameter, the name of a database table

Encrypt$

Takes two parameters, SourceValue, EncryptionKey

EndSession

EnsureFields

Takes two parameters, FieldBase, FieldNames

EnsureNavFields

Takes two parameters, FieldBase, FieldNamesList

Error

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

ETableReply

Takes 2 parameters, Result, Status

ETableStream

Takes two parameters, ExcelTableData, Options

Exception

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

Exists$

Takes two parameters, DBTableName, DBTableRecordAlias

Exit (Proc)

Takes no parameters

Exp%

Takes one parameter, an ExponentValue

Exp10%

Has one parameter, any numeric value.

Exp2%

Takes one parameter, any numeric value.

Extract$

Takes two parameters, Source, Search

ExtractAny$

Takes two parameters, Source , Search 

FailIfRecError

Has no parameters

FieldDef$

Takes one parameter, FieldName

File

Takes 3 parameters, Destination, Action, Source

FileExists$

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

Files

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

FileSize$

Takes one parameter, a value in number of bytes.

FirstAlias$

Takes one parameter, TableName

FixFields

Takes one parameter, a single character

Flush

Takes one parameter, TableName

FlushAll

Has no parameters

Folder

Takes two parameters, FolderPath, Action

FolderExists$

Takes one parameter, the path of the folder

Folders

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

ForEach

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

Foreign

Takes a single parameter, a QueryName

ForeignWith

Takes a single parameter, a FieldBase

Format

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

Format$

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

Function

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

Geo

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

GeoDistance$

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

Get

Takes two parameters, TableName, IfLenFld

GetFieldDefs

Has no parameters.

GoTo

Takes one parameter, a Label

Greg$

Takes one parameter, a gregorian number

Greg%

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

Group

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

Guid$

Takes no parameters

Hash$

Takes two parameters, Source, Options

Hex$

Takes two parameters, SourceValue, Width

Hmac$

Takes two parameters, Source, OptionsAndSecret

Html

Takes 3 parameters, Location, Mode, Text

HtmlAButton

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

HtmlAlert

Takes three parameters, Location, ClassNames, AlertText

HtmlButton

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

HtmlDropdown

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

HtmlDTable

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

HtmlErr

Takes one parameter, ErrMsg

HtmlETable

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

HtmlForm

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

HtmlHistory

Takes two parameters, Title, Path

HtmlJButton

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

HtmlNav

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

HtmlNavbar

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

HtmlPageBreak

Takes two parameters, Location, Mode

HtmlRaw

Takes 3 parameters, Location, Mode, bWithNoHeader

HtmlReset

Has no parameters

HtmlSearchBox

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

HtmlTab

Takes 3 parameters, Location, Mode, bWithNoHeader

HtmlTable

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

HtmlToText$

Takes a single parameter, Source

HtmlUpload

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

Http$

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

HttpCookie

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

HttpHeader

Takes two parameters, name, value

HttpHeader$

Has one parameter

HttpHeaders$

Has no parameters

HttpNoCache

Has no parameters.

HttpsEnsure

Takes no parameters.

HttpSoap$

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

HttpStatus

Takes one parameter, Status

HttpType

Takes one parameter, Type

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

Takes a variable number of conditional statements

If (Not) / Then

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

Image

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

Images

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

Include

Takes one parameter, ProcedureName

IncrKillCount

Has one parameter.

Index%

InStr$

Takes two parameters, Source, Match

InStr%

Takes two parameters, Source, Match

InStrAny$

Takes two parameters, Source, Match

InStrAny%

Takes two parameters, Source, Match

IsGroupType$

Takes two parameters: Username, GroupTypes

IsValidAlias$

Takes one parameter, a Source value

IsValidDBField$

Takes one parameter, a Source value

IsValidTable$

Takes one parameter, a Source value

JoinQuery

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

Json$

Has two parameters: Source, Name

JsonDecode$

Has two parameters: Source, Options

JsonEmbed

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

JsonEncode$

Has two parameters: Source, Options

JsonReply

Has no parameters

JsonStream

Takes two parameters, Data, Options

JsonStream$

Has one parameter, Options

KeepFields

Takes two parameters, FieldBase, FieldNamesList

KeepFirst

Takes no parameters

KeepFor

Takes two parameters, FromIndex, ToIndex

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

KeepIfAll

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

KeepIfAny

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

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

KeepIfSimilar

Takes 3 parameters, FieldBase, pOne, pTwo

KeepLast

Takes no parameters

KeepNone

Takes no parameters

KeepUnique

Takes one parameter, FieldName

Keywords$

Has one parameter.

Lang

Takes four parameters, FieldBase, Destination, Source, IfLenFld

Lang$

Takes one parameter, Source

LangWith

Has one parameter, a Content.Lang prefix

Last$

Takes two parameters, Source , Search 

LastAlias$

Takes one parameter, TableName

LastAny$

Takes two parameters, Source, Search 

LCase$

Takes a single Source parameter

Left$

Takes two parameters, Source, Value

Len$

Takes one parameter, a Source value

Len%

Takes one parameter, a Source value

LFillFields

Takes one parameter, a FieldBase

ListFields

Takes one parameter, TableName

ListFiles

Takes 3 parameters, Folder, Filter, bShowImgSize

ListFolders

Takes two parameters, FolderPath, bRecursive

ListProcs

Takes one parameter, TableName

ListQueries

Takes no parameters

ListRltns

Takes one parameter, TableName

ListTables

Has no parameters

LoadCsvFile

Takes two parameters, FileName, bHasHeader

LoadFile$

Takes one parameter, PathToFile

LoadJsonFile

Takes two parameters, PathToFile, Options

LoadMemUsage

Has no parameters

LoadNulFile

Takes two parameters, FileName, bHasHeader

LoadPipeFile

Takes two parameters, FileName, bHasHeader

LoadPipeFileWS

Takes two parameters, FileName, bHasHeader

LoadRawFile

Takes one parameter, FilePath

LoadRecord

Takes two parameters, TableName, RecordAlias

LoadTabFile

Takes two parameters, FileName, bHasHeader

LoadTabFileWS

Takes two parameters, FileName, bHasHeader

LoadTable

Takes one parameter, TableName

LoadTableFields

Takes one parameter, TableName

LoadTableFiles

Takes one parameter, TableName

Log%

Takes one parameter, Source value

Log10%

Takes one parameter, a Source value

Log2%

Takes one parameter, a Source value

Login

Takes three parameters, Login, Password, bRememberMe

Login$

Takes three parameters, Login, Password, bRememberMe

Logout

Takes one parameter, SessionID

LongDate$

Takes one parameter, a Date value

Lookup

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

Lookup$

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

LookupQuery

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

LTrim$

Takes two parameters, Source, Search

LTrimAny$

Takes two parameters, Source, Search

LTrimFields

Takes one parameter, FieldBaseToTrim

Macro

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

MakeValidAlias$

Takes one parameter, a Source value

MakeValidDBField$

Takes one parameter, Source value

MakeValidTable$

Takes one parameter, Source

MapQuery

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

MarkdownToHtml$

Math

Takes a variable number of parameters

MCase$

Takes one parameter, Source

MergeFields

Takes 4 parameters, FieldBase, Destination, SourceFields, Delimiter

MergeRecords

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

Meta

Takes any unspecified data, intended for use by external systems

Method

Private Method contained within a given procedure.

Month$

Takes one parameter, Source

MoveQuery

Takes two parameters, DestinationQuery, SourceQuery

MsgBox

Takes two parameters, Text, Title

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

NamesToLabels

Takes no parameters

NbSp$

Takes no parameters

New

Takes two parameters, TableName, IfLenFld

NewEComQuery

Takes one parameter, QueryName

NewFields

Takes two parameters, FieldBase, FieldNames

NewQuery

Takes 3 parameters, QueryName, SourceQuery, bWork

NewRecords

Takes one parameter, QuantityToAdd

NewTable

Takes two parameters, TableName, AutoAlias

NewTableField

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

NewTableProc

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

NewTableRltn

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

NewWithAttach

Takes 4 parameters, TableName, Relation, OtherTableName, IfLenFld

NoKillCount

Takes no parameters

NulStream

Takes two parameters, Data, bHasHeader

NulStream$

Takes one parameter, bNoHeader

Num

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

Offset

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

OnError (Continue)

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

PaaS

Takes three parameters, Url, SaaSTenant, InputQuery, OutputQuery

Parents

Takes three parameters, ChildTableName, ParentTableName, Mode

ParentsAlias

Takes three parameters, ChildTableName, ParentTableName, Mode

Parse

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

Parse$

Takes four parameters, Source, bAny, Search, Item

ParseCount$

Takes two parameters, Source and Match

ParseCount%

Takes two parameters, Source and Match

ParseCountAny$

Takes two parameters, Source and Match

ParseCountAny%

Takes two parameters, Source and Match

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

Path$

Takes one parameter, Index

PickFirstField

Takes three parameters, FieldBase, Destination, SourceFields

Pivot

Takes two parameters, FieldBase, PivotField

Plus8Decode

Takes three parameters, FieldBase, Fields, IfLenFld

Plus8Decode$

Takes one parameter, Source

Plus8Encode

Takes three parameters, FieldBase, Fields, IfLenFld

Plus8Encode$

Takes one parameter, Source

Prefix

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

ProcECom

Takes one parameter, QueryName

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

PWHash

Takes three parameters, TableName, Alias, Password

PWHash$

Takes three parameters, TableName, Alias, Password

QBox

Takes two parameters, QueryName, Title

Raw

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

RawStream$

Takes one parameter, a top query destination variable

RecoverHtml$

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

RecoverHtmlObj$

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

RecoverMOX$

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

RecoverTmpl$

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

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.

Remain$

Takes two parameters, Source and Search

RemainAny$

Takes two parameters, Source and Search

Remote

Takes three parameters, Url, InputQuery, OutputQuery

Remove$

Takes two parameters, Source and Search

RemoveAny$

Takes two parameters, Source and Search

ReorderTableFields

Takes two parameters, TableName, FieldList

ReorderTableProcs

ReorderTableRltns

Repeat$

Takes two parameters, Source, Count

Replace$

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

ReplaceAny$

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

Reset

Takes no parameters.

ResetFields

Takes two parameters, FieldBase, FieldNames

ResetTableNextAlias

Takes one parameter, TableName

RetainAny$

Takes two parameters, Source, Search

Return

Takes a variable number of parameters.

Reverse$

Takes one parameter, Source

Right$

Takes two parameters, Source, Value

Rnd%

Takes two parameters, Low, High

RTrim$

Takes two parameters, Source, Search

RTrimAny$

Takes two parameters, Source, Search

SaveCsvFile

Takes two parameters, FilePath, bUseHeader

SaveFile

Takes two parameters, FileName, FileData

SaveHttpFile

Takes two parameters, FileName, URL

SaveJsonFile

Takes two parameters, FileName, Options

SaveNulFile

Takes two parameters, FileName, bUseHeader

SaveRawFile

Takes two parameters, FileName, bUseHeaders

SaveTabFile

Takes two parameters, FileName, bUseHeader

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

Select / Case / End Select

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

SendEmail

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

ServerLog

Takes one parameter, ServerLogText

Session

Takes two parameters, Name, Value

Session$

Takes one parameter, Name

SessionIsGroupType$

Takes one parameter, a List of possible group types

Set

Takes four parameters, FieldBase, Destination, Source, IfLenFld

SetEnsure

Takes two parameters, FieldName, Value

SetFirst

Takes four parameters, FieldBase, Destination, Source, IfLenFld

SetIf

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

SetIfAll

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

SetIfAny

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

SetKillCount

Takes one parameter, Value

SetLast

Takes four parameters, FieldBase, Destination, Source, IfLenFld

SetNew

Takes four parameters, FieldBase, FieldName, Source, IfLenFld

Setup

Takes two parameters, Name, Value

Setup$

Takes one parameter, Name

Sgn%

Takes one parameter, Value

Similar$

Takes 2 parameters, pString1, pString2

Similar%

Takes 2 parameters, pNum1, pNum2

Sin%

Takes one parameter, Value

SkipCalls

Takes no parameters

Sleep

Takes one parameter.

Sort

Takes two parameters, FieldBase, SortFieldList

Sqr%

Takes one parameter, Value

SSColAlpha$

Takes one parameter, Source

SSColNum$

Takes one parameter, Source

SSReference

A command to help build spreadsheets

TabStream

Takes two parameters, Data, bHasHeader

TabStream$

Takes one parameter, bNoHeaders

Tally$

Takes two parameters, Source, Match

Tally%

Takes two parameters, Source, Match

TallyAny$

Takes two parameters, Source, Match

TallyAny%

Takes two parameters, Source, Match

Tan%

Takes one parameter, Value

Tcp$

Takes three parameters, ServerName, Port, bSecure, Send

TemplateCustom

Takes one parameter, TemplateData

TemplateName

Takes one parameter, Name

TemplateRuntime

Takes one parameter, Name

TemplateType

Takes one parameter, Type

Text

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

TextToHtml$

Takes one parameter, Source

Thread

Takes a variable number of parameters

Throttle / End Throttle

Takes one parameter, SlowWritePercent

Time

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

Time$

Takes one parameter, Source

TimeAdd$

Takes two parameters, Source, Value

TimeDif$

Takes two parameters, Source, Value

TimeSub$

Takes two parameters, Source, Value

TimeZone$

Takes two parameters, Source, Value

TopField

Takes one parameter, FieldName

TopQuery

Takes one parameter, FieldBase

TopWith

Takes one parameter, FieldBase

Trigger

Takes two parameter, URL, InputQuery

Trim$

Takes two parameters, Source, Search

TrimAny$

Takes two parameters, Source, Match

TRON

Takes one parameter, FilePath

TRONLog

Takes one parameter, OutputText

Truncate$

Takes two parameters, Source, MinLength

Try / Catch / Finally / End Try

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

UCase$

Takes one parameter, Source

Uncompress$

UnloadTableFiles

Takes one parameter, TableName

Update

Takes two parameters, TableName, IfLenFld

UpdateOrNew

Takes two parameters, TableName, IfLenFld

UpdateOrNewWithAttach

Takes four parameters, TableName, Relation, OtherTableName, IfLenFld

UpdateTableField

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

UpdateTableProc

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

UpdateTableRltn

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

UrlDecode$

Takes one parameter, Source

UrlEncode$

Takes one parameter, Source

Utf16ToAnsi$

Takes one parameter, Source

Utf16ToUtf8$

Takes one parameter, Source

Utf8ToAnsi$

Takes one parameter, Source

Utf8ToUtf16$

Takes one parameter, Source

ValidDate$

Takes one parameter, a Source value.

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

Verify$

Takes two parameters, Source, AllowedCharacters (case sensitive)

Verify%

Takes two parameters, Source, AllowedCharacters (case sensitive)

WebSafe$

Takes one parameter, Source

WithAll

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

WithGroup

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

WorkIf

Takes one parameter, FieldName

WorkQuery

Takes one parameter, QueryName

WorkWith

Takes one parameter, FieldBase

XmlMerge

Takes two parameters, [WorkWith]+Scope, EmbedScope

XmlStream

Takes one parameter, Data

Year$

Takes one parameter, Source

[ ? ] Pick First (Top Query)

Parameter is a space separated list of fields to choose from

[!] 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

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

[#] Format (Top Query)

Takes 1 parameter, a formatting mask

[$] Currency (Top Query)

Takes one parameter, Source

[AnyRecError]

Takes no parameters.

[CountIf]

Takes one parameter, TestCondition

[DateTime] (Top Query)

Has no parameters

[Date] (Top Query)

Has no parameters

[Ensure] Field Exists

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

[HtmlOutput]

Takes a variable number of parameters

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

[L] Lookup (Top Query)

Takes one parameter.

[Meta]

Takes no parameters

[Me]

Takes no parameters

[New] Field

Takes one parameter, a comma separated list of FieldNames

[Pull] List of Fields from another Query

Takes three parameters, QueryName, FieldBase, FieldNames

[Reset]

Fields

[TemplateName]

Takes no parameters

[TemplateType]

Takes no parameters

[Time] (Top Query)

Has no parameters

[TQFieldList]

Takes no parameters

[TQFldCount]

Takes no parameters

[TQMessage]

Takes one parameter, Message, or no parameters

[TQName]

Has no parameters

[TQRecCount]

Has no parameters

[TQResult]

Takes either one parameter, ResultValue, or no parameters

[WQFieldList]

Has no parameters

[WQFldCount]

Takes no parameters

[WQMessage]

Takes one parameter, Message, or no parameters

[WQName]

Has no parameters

[WQRecCount]

Has no parameters

[WQResult]

Takes either one parameter, ResultValue, or no parameters

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

Takes 1 parameter, a formatting mask

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

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

[_DateTime] If not blank (Top Query)

Has no parameters

[_Date] If not blank (Top Query)

Has no parameters

[_Time] if not blank (Top Query)

Has no parameters