Top Query Functions, MOX Keywords

 

Abs%

Has one parameter, a numeric value.

Read more...

 

AmPm$

Takes one parameter

Read more...

 

AnsiToUtf16$

Has one parameter.

Read more...

 

AnsiToUtf8$

Has one parameter.

Read more...

 

ApplyLang$

Takes one parameter

Read more...

 

ATn%

Takes one parameter

Read more...

 

Bin$

Takes one parameter

Read more...

 

CFApi$

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

Read more...

 

CheckPw$

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

Read more...

 

Chr$

Takes one parameter

Read more...

 

Compress$

Compress any value/table

Read more...

 

Cos%

Takes one parameter

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

 

Dir$

Takes one parameter, a path-mask

Read more...

 

DnsIp$

Takes one parameter, a domain name

Read more...

 

DnsName$

Takes one parameter, an IPv4 Address

Read more...

 

Encrypt$

Takes two parameters, SourceValue, EncryptionKey

Read more...

 

Exists$

Takes two parameters, DBTableName, DBTableRecordAlias

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

 

FieldDef$

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

Read more...

 

FileExists$

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

Read more...

 

FileSize$

Takes one parameter, a value in number of bytes.

Read more...

 

FirstAlias$

Takes one parameter, TableName

Read more...

 

FolderExists$

Takes one parameter, the path of the folder

Read more...

 

Format$

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

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

 

Guid$

Takes no parameters

Read more...

 

Hash$

Takes one parameter, a source value

Read more...

 

Hex$

Takes one parameter, a source value

Read more...

 

HtmlToText$

Takes a single parameter, Source

Read more...

 

Http$

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

Read more...

 

HttpSoap$

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

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

 

JsonStream$

Used to manipulate a WorkQuery into a JSON type

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

 

LoadFile$

Takes one parameter, PathToFile

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

 

LongDate$

Takes one parameter, a Date value

Read more...

 

Lookup$

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

Read more...

 

LTrim$

Takes two parameters, Source, Search

Read more...

 

LTrimAny$

Takes two parameters, Source, Search

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

 

 

MCase$

Takes one parameter, Source

Read more...

 

Month$

Takes one parameter, Source

Read more...

 

NbSp$

Takes no parameters

Read more...

 

NulStream$

Takes one parameter, bNoHeader

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

 

Plus8Decode$

Takes one parameter, Source

Read more...

 

Plus8Encode$

Takes one parameter, Source

Read more...

 

 

RecoverHtml$

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

Read more...

 

 

 

 

 

Remain$

Takes two parameters, Source and Search

Read more...

 

RemainAny$

Takes two parameters, Source and Search

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

 

 

RetainAny$

Takes two parameters, Source, Search

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

 

Session$

Takes one parameter, Name

Read more...

 

SessionIsGroupType$

Takes one parameter, a List of possible group types

Read more...

 

Setup$

Takes one parameter, Name

Read more...

 

Sgn%

Takes one parameter, Value

Read more...

 

 

 

Sin%

Takes one parameter, Value

Read more...

 

Sqr%

Takes one parameter, Value

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

 

TextToHtml$

Takes one parameter, Source

Read more...

 

Time$

Takes one parameter, Source

Read more...

 

Trim$

Takes two parameters, Source, Search

Read more...

 

TrimAny$

Takes two parameters, Source, Match

Read more...

 

Truncate$

Takes two parameters, Source, MinLength

Read more...

 

UCase$

Takes one parameter, Source

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

 

 

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

 

Year$

Takes one parameter, Source

Read more...