Search Results for error

 

Error

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

 

[State] Error State

Takes one parameter.

 

FailIfRecError

Has no parameters

 

[AnyRecError]

Takes no parameters.

 

OnError (Continue)

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

 

 

Folder and File Structure

Brief overview on the file structure and contents under Moxie. The files and folders discussed in this post are those that are essential when upgrading to the most recent version of Moxie.Build , or when troubleshooting server errors.

 

Try / Catch / Finally / End Try

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

 

DeleteTable

Takes one parameter, TableName

 

Delete

Takes two parameters, TableName and a boolean expression

 

DetachWithDelete

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

 

Get

Takes two parameters, TableName, IfLenFld

 

Login

Takes three parameters, Login, Password, bRememberMe

 

Detach

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

 

PWHash$

Takes three parameters, TableName, Alias, Password

 

HtmlAlert

Takes three parameters, Location, ClassNames, AlertText

 

Lang$

Takes one parameter, Source

 

Login$

Takes three parameters, Login, Password, bRememberMe

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

Backfill

Has no parameters

 

HtmlErr

Takes one parameter, ErrMsg

 

HtmlHistory

Takes two parameters, Title, Path

 

Reset

Takes no parameters.

 

Parse

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

 

NewFields

Takes two parameters, FieldBase, FieldNames

 

ResetFields

Takes two parameters, FieldBase, FieldNames

 

Lang

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

 

SSReference

A command to help build spreadsheets

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

 

Update

Takes two parameters, TableName, IfLenFld

 

PWHash

Takes three parameters, TableName, Alias, Password

 

New

Takes two parameters, TableName, IfLenFld

 

UpdateOrNew

Takes two parameters, TableName, IfLenFld

 

KeepFor

Takes two parameters, FromIndex, ToIndex

 

KeepFields

Takes two parameters, FieldBase, FieldNamesList

 

DeleteFields

Takes two parameters, FieldBase, FieldNameList

 

Licensing

Moxie.Build, in short, may be used and licensed free of charge for education and non-profit organizations. Whenever it is used by government or for-profit organizations the license is granted on a subscription basis.

Moxie.Build includes a number of open source components as part of its distribution; each is subject to their own licenses as included with the files for those components.

 

[Ensure] Field Exists

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

 

EmailErr

Takes two parameters, SubjectPrefix, EmailBody

 

IncrKillCount

Has one parameter.

 

GoTo

Takes one parameter, a Label

 

 

[Ajax]

Takes 3 parameters, Trigger, DestinationID, Path

 

[Raw] Raw HTML

Accepts one parameter which is the raw HTML content to be placed in the form at the Field's location.

 

[!] Limited Selection List

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.

 

Critical

Takes one parameter, the Name of the critical section

 

Message Handler

A Message Handler is only ever called by the Database on a Database Event. These Event Messages allow a Developer to intercept operations taking place on a per-record level and implement Event based business logic.

 

Export and Import of Database Schema

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

 

[CountIf]

Takes one parameter, TestCondition

 

Nightly Management Utility

This utility program manages a server install with one or many Moxie.Build services running by taking care of nightly tasks via a scheduled task.

 

[L] Lookup (Top Query)

Takes one parameter.

 

Http$

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

 

GeoDistance$

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

 

Moxie.cfg Config

The Moxie.cfg file is read on server start and controls aspects that cannot be changed while the server is running.

 

SetKillCount

Takes one parameter, Value

 

NewEComQuery

Takes one parameter, QueryName

 

TRONLog

Takes one parameter, OutputText

 

Command Line with .mox file

A .mox file, with MOX code in it, can be run from the command line while a Moxie.Build system is not otherwise already running.