Search Results for create

 

[D] Default Value

Parameter is a value or an expression to be used when a record is created if no value is specified during the creation. The value or expression is run through the Assignment Attribute in order to calculate it's result.

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

Delete

Takes two parameters, TableName and a boolean expression

 

AppendTable

Takes one parameter, TableName

 

HttpCookie

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

 

TemplateCustom

Takes one parameter, TemplateData

 

ListRltns

Takes one parameter, TableName

 

New

Takes two parameters, TableName, IfLenFld

 

ListProcs

Takes one parameter, TableName

 

Detach

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

 

ListFields

Takes one parameter, TableName

 

HtmlHistory

Takes two parameters, Title, Path

 

TopQuery

Takes one parameter, FieldBase

 

Cloudflare Origin Certificates

Cloudflare automatically provides free client-facing certificates for your domain, even if using their free service. In addition, they provide free Origin Certificates to encrypt the connection between Cloudflare and your origin Moxie.Build server. Use this article if you are going to have Cloudflare connect to inbound open ports on your Moxie.Build server.

 

SaveFile

Takes two parameters, FileName, FileData

 

ProcECom

Takes one parameter, QueryName

 

Return

Takes a variable number of parameters.

 

RawStream$

Takes one parameter, a top query destination variable

 

HtmlAlert

Takes three parameters, Location, ClassNames, AlertText

 

CFApi$

Takes three parameters Method, URL, Body

 

Moxie.cfg Config

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

 

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

 

SetNew

Takes four parameters, FieldBase, FieldName, Source, IfLenFld

 

Text

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

 

SetIf

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

 

Pivot

Takes two parameters, FieldBase, PivotField

 

SaveRawFile

Takes two parameters, FileName, bUseHeaders

 

HtmlForm

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

 

HtmlTab

Takes 3 parameters, Location, Mode, bWithNoHeader

 

HtmlETable

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

 

Time

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

 

HtmlDTable

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

 

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

 

NewTableRltn

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

 

Session

Takes two parameters, Name, Value

 

NewTableProc

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

 

HtmlTable

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

 

NewTableField

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

 

ListFiles

Takes 3 parameters, Folder, Filter, bShowImgSize

 

ListQueries

Takes no parameters

 

JsonEmbed

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

 

Setup

Takes two parameters, Name, Value

 

Update

Takes two parameters, TableName, IfLenFld

 

[Placeholder]

Takes one parameter

 

[Ajax]

Takes 3 parameters, Trigger, DestinationID, Path

 

Templates Documentation

Prerequisites: This tutorial assumes that you have already learned about Managing Files .

 

[Raw] Raw HTML

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

 

 

[Sort] (DB Relationship Attribute)

Accepts a space separated list of field names.

 

[Temp] Field

Parameter is a single new field name or a space separated list of new field names.

 

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.

 

 

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.

 

Get Started with Service Setup on a Server

A single Windows OS can host many instances of Moxie.Build, these steps will guide you through the setup process.

 

Learn More about Frontend Development

Prerequisites: This tutorial assumes that you have already set up a Category and Procedure if necessary. This page covers some of the basics that are involved in Front End development using the MOX language.

 

 

 

Learn More About Managing Files

Prerequisites: This tutorial assumes that you have already set up your Moxie.Build server and logged in. This page covers some of the basics that are involved in managing files and folders in the Moxie.Build system.

 

Export and Import of Database Schema

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

 

LangWith

Has one parameter, a Content.Lang prefix

 

JoinQuery

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

 

Function

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

 

MapQuery

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

 

OnError (Continue)

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

 

NewQuery

Takes 3 parameters, QueryName, SourceQuery, bWork

 

NewEComQuery

Takes one parameter, QueryName

 

AppendQuery

Takes 3 parameters, DestinationQuery, SourceQuery, bMoveIt

 

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.

 

Table Action

Table Actions are presented to the users of the Default Admin interface and are also intended to be made available in a dynamic way to users of a customized front end. As an Action, the Procedure is expected to perform some sort of task, such as an automated set of updates to the Database Table.

 

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 , or when troubleshooting server errors.

 

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.

 

Table Report

Table Reports are presented to the users of the Default Admin interface and are also intended to be made available in a dynamic way to users of a customized front end. As a Report, the Procedure is expected to produce output to be displayed to the user.

 

Record Report

Record Reports are presented to the users of the Default Admin interface and are also intended to be made available in a dynamic way to users of a customized front end. As a Report, the Procedure is expected to produce output to be displayed to the user.

 

Record Action

Record Actions are presented to the users of the Default Admin interface and are also intended to be made available in a dynamic way to users of a customized front end. As an Action, the Procedure is expected to perform some sort of task, such as an automated set of updates to the Database Record.