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

 

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.

 

Setup Table

The Setup Table controls aspects that can be changed while the server is running, and is intended to contain both Moxie.Build specific values as well as application specific.

 

Moxie.cfg Config

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

 

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.

 

CFApi$

Takes three parameters Method, URL, Body

 

HtmlAlert

Takes three parameters, Location, ClassNames, AlertText

 

HtmlHistory

Takes two parameters, Title, Path

 

TabStream$

Takes one parameter, bNoHeaders

 

CsvStream$

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

 

RawStream$

Takes one parameter, a top query destination variable

 

NewTableField

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

 

Text

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

 

Time

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

 

SetNew

Takes four parameters, FieldBase, FieldName, Source, IfLenFld

 

SaveRawFile

Takes two parameters, FileName, bUseHeaders

 

SetIf

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

 

HtmlTab

Takes 3 parameters, Location, Mode, bWithNoHeader

 

HtmlTable

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

 

HtmlForm

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

 

HtmlDTable

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

 

HtmlETable

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

 

Pivot

Takes two parameters, FieldBase, PivotField

 

Setup

Takes two parameters, Name, Value

 

Update

Takes two parameters, TableName, IfLenFld

 

Session

Takes two parameters, Name, Value

 

NewTableProc

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

 

NewTableRltn

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

 

ListQueries

Takes no parameters

 

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

 

ListFiles

Takes 3 parameters, Folder, Filter, bShowImgSize

 

JsonEmbed

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

 

JsonStream

Takes two parameters, Data, Options

 

SaveFile

Takes two parameters, FileName, FileData

 

[Placeholder]

Takes one parameter

 

[Raw] Raw HTML

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

 

Templates Documentation

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

 

[Ajax]

Takes 3 parameters, Trigger, DestinationID, Path

 

 

Export and Import of Database Schema

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

 

[Temp] Field

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

 

[Sort] (DB Relationship Attribute)

Accepts a space separated list of field names.

 

 

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.

 

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.

 

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.

 

Help with Markdown

Markdown enables simple formatting of plain text via easy to remember conventions. This page will provide you with some pointers on what formatting options are available with "Moxie Flavored Markdown".

 

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.

 

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.

 

 

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.

 

MapQuery

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

 

NewEComQuery

Takes one parameter, QueryName

 

JoinQuery

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

 

LangWith

Has one parameter, a Content.Lang prefix

 

ProcECom

Takes one parameter, QueryName

 

Return

Takes a variable number of parameters.

 

NewQuery

Takes 3 parameters, QueryName, SourceQuery, bWork

 

OnError (Continue)

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

 

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.

 

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.

 

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.

 

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.

 

AppendQuery

Takes 3 parameters, DestinationQuery, SourceQuery, bMoveIt

 

Function

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

 

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.

 

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.