Search Results for return

 

Return

Takes a variable number of parameters.

 

Function

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

 

RecoverHtmlObj$

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

 

RecoverHtml$

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

 

CsvStream$

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

 

RemainAny$

Takes two parameters, Source and Search

 

Remain$

Takes two parameters, Source and Search

 

ParseCountAny$

Takes two parameters, Source and Match

 

ParseCountAny%

Takes two parameters, Source and Match

 

Remove$

Takes two parameters, Source and Search

 

Rnd%

Takes two parameters, Low, High

 

Right$

Takes two parameters, Source, Value

 

SessionIsGroupType$

Takes one parameter, a List of possible group types

 

Session$

Takes one parameter, Name

 

Repeat$

Takes two parameters, Source, Count

 

RemoveAny$

Takes two parameters, Source and Search

 

Reverse$

Takes one parameter, Source

 

RetainAny$

Takes two parameters, Source, Search

 

ParseCount$

Takes two parameters, Source and Match

 

Log%

Takes one parameter, Source value

 

Len$

Takes one parameter, a Source value

 

Log2%

Takes one parameter, a Source value

 

Log10%

Takes one parameter, a Source value

 

LCase$

Takes a single Source parameter

 

LastAny$

Takes two parameters, Source , Search

 

Len%

Takes one parameter, a Source value

 

Left$

Takes two parameters, Source, Value

 

Month$

Takes one parameter, Source

 

MCase$

Takes one parameter, Source

 

ParseCount%

Takes two parameters, Source and Match

 

NbSp$

Takes no parameters

 

Lookup$

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

 

LongDate$

Takes one parameter, a Date value

 

LTrimAny$

Takes two parameters, Source, Search

 

LTrim$

Takes two parameters, Source, Search

 

Setup$

Takes one parameter, Name

 

EmptyTable

Takes one parameter, the name of a database table

 

HttpType

Takes one parameter, Type

 

Group

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

 

Get

Takes one parameter, a TableName

 

Year$

Takes one parameter, Source

 

Verify$

Takes two parameters, Source, AllowedCharacters (case sensitive)

 

HttpStatus

Takes one parameter, Status

 

HttpCookie

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

 

SaveJsonFile

Takes two parameters, FileName, Options

 

Plus8Encode

Takes three parameters, FieldBase, Fields, IfLenFld

 

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

 

SSReference

A command to help build spreadsheets

 

ListFolders

Takes two parameters, FolderPath, bRecursive

 

JsonStream

Used to manipulate a WorkQuery into a JSON type

 

Parse

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

 

ListQueries

Takes no parameters

 

TabStream$

Takes one parameter, bNoHeaders

 

Sqr%

Takes one parameter, Value

 

Tally$

Takes two parameters, Source, Match

 

Tally%

Takes two parameters, Source, Match

 

Similar%

Takes 2 parameters, pNum1, pNum2

 

Sgn%

Takes one parameter, Value

 

Sin%

Takes one parameter, Value

 

Similar$

Takes 2 parameters, pString1, pString2

 

Truncate$

Takes two parameters, Source, MinLength

 

TrimAny$

Takes two parameters, Source, Match

 

Verify%

Takes two parameters, Source, AllowedCharacters (case sensitive)

 

UCase$

Takes one parameter, Source

 

TallyAny$

Takes two parameters, Source, Match

 

TallyAny%

Takes two parameters, Source, Match

 

Trim$

Takes two parameters, Source, Search

 

Tan%

Takes one parameter, Value

 

LastAlias$

Takes one parameter, TableName

 

Abs%

Has one parameter, a numeric value.

 

ATn%

Takes one parameter

 

Bin$

Takes one parameter

 

[WQName]

Has no parameters

 

[TQName]

Has no parameters

 

[WQFieldList]

Has no parameters

 

[WQFldCount]

Takes no parameters

 

CFApi$

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

 

Day$

Takes one parameter, a date

 

DayOfWeek$

Takes one parameter, a date

 

Decrypt$

Takes two parameters, an encrypted value and the decryption key

 

Currency$

Takes one parameter, a numeric value

 

CheckPw$

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

 

Chr$

Takes one parameter

 

Cos%

Takes one parameter

 

[TQFldCount]

Takes no parameters

 

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

 

Public Method

A Public Method may be called from any other Procedure, by the Default plug-in, or a Custom COM DLL. Each Public Method may either use specific Input Parameters, or it may accept an Input Query.

 

Remote Method

A Remote Method may be called by any other Moxie system. It can be used to divide up a large system among a number of backend servers, or as a public API for 3rd parties. In order to call a Remote Method from MOX, the Remote statement is used.

 

[Ajax]

Takes 3 parameters, Trigger, DestinationID, Path

 

 

Overview for PHP Developers

This hands-on experience article is written by an experienced PHP developer, and serves as an overview to help you understand the similarities and differences.

 

Syntax and Builtin Values, Procedures and Code Documentation

The MOX language pays heritage to BASIC, but has been crafted for the specific type of work and environment that is demanded of Moxie.Build.

 

Exit (Proc)

Takes no parameters

 

[CountIf]

Takes one parameter, TestCondition

 

[HtmlOutput]

Takes a variable number of parameters

 

[TQFieldList]

Takes no parameters

 

[AnyRecError]

Takes no parameters.

 

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

Takes a variable number of conditional statements

 

NewEComQuery

Takes one parameter, QueryName

 

Try / Catch / Finally / End Try

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

 

HttpSoap$

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

 

InStr%

Takes two parameters, Source, Match

 

InStr$

Takes two parameters, Source, Match

 

Http$

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

 

Hash$

Takes one parameter, a source value

 

Hex$

Takes one parameter, a source value

 

HtmlToText$

Takes a single parameter, Source

 

InStrAny%

Takes two parameters, Source, Match

 

JsonStream$

Used to manipulate a WorkQuery into a JSON type

 

Lang$

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

Last$

Takes two parameters, Source , Search

 

IsValidTable$

Takes one parameter, a Source value

 

InStrAny$

Takes two parameters, Source, Match

 

IsValidAlias$

Takes one parameter, a Source value

 

IsValidDBField$

Takes one parameter, a Source value

 

Guid$

Takes no parameters

 

Exists$

Takes two parameters, DBTableName, DBTableRecordAlias

 

Exp10%

Has one parameter, any numeric value.

 

Exp2%

Takes one parameter, any numeric value.

 

Encrypt$

Takes two parameters, SourceValue, EncryptionKey

 

Dir$

Takes one parameter, a path-mask

 

DnsIp$

Takes one parameter, a domain name

 

DnsName$

Takes one parameter, an IPv4 Address

 

Extract$

Takes two parameters, Source, Search

 

FolderExists$

Takes one parameter, the path of the folder

 

Greg%

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

 

Greg$

Takes one parameter, a gregorian number

 

FirstAlias$

Takes one parameter, TableName

 

ExtractAny$

Takes two parameters, Source , Search

 

FileExists$

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

 

FileSize$

Takes one parameter, a value in number of bytes.