Search Results for character

 

Verify%

Takes two parameters, Source, AllowedCharacters (case sensitive)

 

[AccKey] Keyboard Accelorator Key

Takes one parameter which is the keyboard key which will be used as the Access Key for a given Database Table's field.

*Note: By default, each Field's Access Key will be initialized to the first character of the Field's Label.

 

Verify$

Takes two parameters, Source, AllowedCharacters (case sensitive)

 

FixFields

Takes one parameter, a single character

 

Using the Backtick `

Some Work Query command parameters can accept a source of either a Work Query Field name or a text literal. Text literals in these cases are prefixed with a backtick ` character.

 

Utf16ToUtf8$

Takes one parameter, Source

 

Utf8ToAnsi$

Takes one parameter, Source

 

ListFields

Takes one parameter, TableName

 

HttpCookie

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

 

Utf8ToUtf16$

Takes one parameter, Source

 

Utf16ToAnsi$

Takes one parameter, Source

 

Similar$

Takes 2 parameters, pString1, pString2

 

TallyAny%

Takes two parameters, Source, Match

 

RTrimAny$

Takes two parameters, Source, Search

 

Similar%

Takes 2 parameters, pNum1, pNum2

 

TallyAny$

Takes two parameters, Source, Match

 

Truncate$

Takes two parameters, Source, MinLength

 

UCase$

Takes one parameter, Source

 

Trim$

Takes two parameters, Source, Search

 

TrimAny$

Takes two parameters, Source, Match

 

Num

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

 

Parse

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

 

LoadRawFile

Takes one parameter, FilePath

 

LoadTabFile

Takes two parameters, FileName, bHasHeader

 

Text

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

 

NamesToLabels

Takes no parameters

 

Plus8Encode

Takes three parameters, FieldBase, Fields, IfLenFld

 

TabStream

Takes two parameters, Data, bHasHeader

 

LoadNulFile

Takes two parameters, FileName, bHasHeader

 

ReorderTableFields

Takes two parameters, TableName, FieldList

 

ReorderTableProcs

Takes two parameters, TableName, ProcList

 

ListProcs

Takes one parameter, TableName

 

ListRltns

Takes one parameter, TableName

 

ETableStream

Takes two parameters, ExcelTableData, Options

 

LoadCsvFile

Takes two parameters, FileName, bHasHeader

 

ReorderTableRltns

Takes two parameters, TableName, RltnList

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

RTrim$

Takes two parameters, Source, Search

 

InStr$

Takes two parameters, Source, Match

 

InStrAny%

Takes two parameters, Source, Match

 

Chr$

Takes one parameter

 

InStr%

Takes two parameters, Source, Match

 

IsValidDBField$

Takes one parameter, a Source value

 

IsValidTable$

Takes one parameter, a Source value

 

InStrAny$

Takes two parameters, Source, Match

 

IsValidAlias$

Takes one parameter, a Source value

 

[If] Assignment (DB Field Attribute)

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.

 

[MaxLen]

Accepts a numeric value as a parameter.

 

Get Started with Setting up the Development Environment

Developing in Moxie.Build on localhost give you the advantage of working with the template files natively. When working on procedures (MOX code) you need to access that through the Procedures page in the Admin area of a Moxie.Build system, if running the server on localhost or on a remote server. When running on a remote server, you can edit the template files via the Files page in the Admin area.

 

MOX Coding and Programing Language Syntax Documentation

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

 

ServerLog

Takes one parameter, ServerLogText

 

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

 

[Score] 0.0 to 10

Accepts 3 parameters, first is required, 2nd and 3rd are optional. A trailing optional expression after an = sign may also assign a value on the same line.

 

Export and Import of Database Schema

ExportSchema and ImportSchema are BuiltIn procedures that are available for use with source control systems.

 

RecoverMOX$

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

 

Remain$

Takes two parameters, Source and Search

 

MakeValidTable$

Takes one parameter, Source

 

MCase$

Takes one parameter, Source

 

RetainAny$

Takes two parameters, Source, Search

 

Right$

Takes two parameters, Source, Value

 

RemainAny$

Takes two parameters, Source and Search

 

RemoveAny$

Takes two parameters, Source and Search

 

Len%

Takes one parameter, a Source value

 

Len$

Takes one parameter, a Source value

 

LastAny$

Takes two parameters, Source, Search

 

Left$

Takes two parameters, Source, Value

 

MakeValidAlias$

Takes one parameter, a Source value

 

MakeValidDBField$

Takes one parameter, Source value

 

LTrim$

Takes two parameters, Source, Search

 

LTrimAny$

Takes two parameters, Source, Search