Search Results for place

 

[Placeholder]

Takes one parameter

 

ReplaceAny$

Takes one existing Source value, and two parameters of equal length, SearchVals, NewVals

 

Replace$

Takes one existing Source value, and two parameters, Search, NewVal

 

[Raw] Raw HTML

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

 

[Header] Raw HTML

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

 

[Footer] Raw HTML

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

 

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.

 

Download Moxie.Build

Upgrade Notes
In order to Upgrade an existing copy of Moxie.Build V4 or V5 to the most recent version of V5, you can use the Upgrade example files found in the Tools folder to help automate upgrading multi-service systems, or you can just replace the following files/folders:
Moxie.exe
Moxie.dll
Default.dll
/DBStore/BuiltIn.*
/Lib
/Public/BuiltIn
/Templates/Admin
/Templates/Clean
/Templates/Default
/Templates/Default5
/Templates/Report

 

Lookup

Takes six parameters, FieldBase, Destination, Table, Alias, SourceField, IfLenFld

 

New

Takes two parameters, TableName, IfLenFld

 

PWHash

Takes three parameters, TableName, Alias, Password

 

ResetTableNextAlias

Takes one parameter, TableName

 

FixFields

Takes one parameter, a single character

 

Folders

Takes 5 parameters, FieldBase, FolderPath, Action, Source, IfLenFld

 

Format

Takes five parameters, FieldBase, FieldList, Mask, bBlanks2Zero, IfLenFld

 

Files

Takes 5 parameters, FieldBase, Destination, Action, Source, IfLenFld

 

Update

Takes two parameters, TableName, IfLenFld

 

Build

Takes a variable number of parameters

 

EnsureNavFields

Takes two parameters, FieldBase, FieldNamesList

 

LoadTableFields

Takes one parameter, TableName

 

HtmlBlock / End HtmlBlock

Takes two parameters, Location, Mode

 

HtmlAlert

Takes three parameters, Location, ClassNames, AlertText

 

HtmlJButton

Takes 6 parameters, Location, Mode, ActionLabel, ActionScript, Class, Extra.

 

HtmlButton

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

 

WebSafe$

Takes one parameter, Source

 

TextToHtml$

Takes one parameter, Source

 

HtmlAButton

Takes 6 parameters, Location, Mode, ActionLabel, ActionPath, Class, Extra.

 

Html

Takes 3 parameters, Location, Mode, Text

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

TemplateType

Takes one parameter, Type

 

Detach

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

 

Delete

Takes two parameters, TableName and a boolean expression

 

HtmlReset

Has no parameters

 

HtmlPageBreak

Takes two parameters, Location, Mode

 

HttpCookie

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

 

HtmlUpload

Takes seven parameters, Location, Mode, Prompt, Path, Class, Name, HelpText

 

HtmlBlocks / End HtmlBlocks

Takes two parameters, Location, Mode

 

HtmlDropdown

Takes 5 parameters, Location, Mode, Title, Element, Class

 

HtmlDTable

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

 

XmlMerge

Takes two parameters, [WorkWith]+Scope, EmbedScope

 

Text

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

 

Time

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

 

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

 

HtmlETable

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

 

HtmlTab

Takes 3 parameters, Location, Mode, bWithNoHeader

 

Lang

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

NamesToLabels

Takes no parameters

 

HtmlRaw

Takes 3 parameters, Location, Mode, bWithNoHeader

 

HtmlForm

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

 

HtmlNav

Takes 7 parameters, Location, Mode, Title, TitleLink, Class, HtmlPre, HtmlApn

 

HtmlNavbar

Takes 10 parameters, Location, Mode, Title, TitleLink, Class, Fixed, bUseContainer, bNotResponsive, bInverted, HtmlPre, HtmlApn

 

MergeRecords

Takes 5 parameters, FieldBase, GroupBy, MergeField, Delimiter, bKeepBlanks

 

Num

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

 

Offset

Takes 7 parameters, FieldBase, Destination, Source, OffsetVal, Operator, OpValue, IfLenFld

 

MergeFields

Takes 4 parameters, FieldBase, Destination, SourceFields, Delimiter

 

Geo

Takes nine parameters, FieldBase, Destination, Function, Source1, Source2, Source3, Source4, Options, IfLenFld

 

Images

Takes up to 6 parameters, FieldBase, Destination, Action, Source, Value, IfLenField

 

JsonEmbed

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

 

Parse

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

 

SetIfAll

Takes a variable number of parameters, FieldBase, Destination, Source, Test1, Test2, [etc...]

 

SetIfAny

Takes a variable number of parameters, FieldBase, Destination, Source, Test1, Test2, [etc...]

 

SSReference

A command to help build spreadsheets

 

SetIf

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

 

PickFirstField

Takes three parameters, FieldBase, Destination, SourceFields

 

Pivot

Takes two parameters, FieldBase, PivotField

 

Plus8Encode

Takes three parameters, FieldBase, Fields, IfLenFld

 

[SearchSort]

Parameter is a space separated list of field names to have the display table sorted by when displaying search results in the Admin interface.

 

[FieldList]

Parameter is a space separated list of field names to be displayed.

 

[Sort] (DB Relationship Attribute)

Accepts a space separated list of field names.

 

[RowCols]

Takes three parameters

 

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

 

[SearchFieldList]

Parameter is a space separated list of field names to be displayed when the user is viewing results from the Search List in the Admin interface.

 

Public Method

A Public Method may be called from any other Procedure, by the Default plug-in as part of the CMS.

 

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.

 

Public Method WorkQuery Example

In this example, you will see how to use a public method that works on or with the current WorkQuery that you pass into the method.

 

Export and Import of Database Schema

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

 

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.

 

PaaS Method

A PaaS Method may be called by any other Moxie system. In order to call a PaaS Method from MOX, the PaaS statement is used.

 

Learn More About the Content Management System

Prerequisites: This page assumes that you have already set up your Moxie.Build server and logged in as an admin user. This page covers some of the basics that are involved in using the Content Management aspects of the Moxie.Build system.

 

 

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

 

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.

 

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.

 

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

 

[L] Lookup (DB Field Attribute)

Takes one parameter.

 

[Max]

Accepts a numeric value as a parameter.

 

Style Guide, Procedures and Code Documentation

This style guide provides comprehensive standards for writing clean, maintainable, and consistent MOX code for Moxie.Build. Code examples on this page are for illustrative purposes and are only intended to demonstrate style conventions.

 

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.

 

[Ajax]

Takes 3 parameters, Event, DestinationID, Path

 

AppendFile

Takes two parameters, FileName, FileData

 

DateTime$

Takes one parameter, Source

 

Http$

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

 

IsGroupType$

Takes two parameters: Username, GroupTypes

 

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

 

[L] Lookup (Top Query)

Takes one parameter.

 

Currency$

Takes one parameter, a numeric value

 

MakeValidTable$

Takes one parameter, Source

 

PWHash$

Takes three parameters, TableName, Alias, Password

 

RecoverHtmlObj$

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

 

Lang$

Takes one parameter, Source

 

MakeValidAlias$

Takes one parameter, a Source value

 

MakeValidDBField$

Takes one parameter, Source value

 

Macro

A set of instructions that can be called with parameters to run in the current scope.

 

[New] Field

Takes one parameter, a comma separated list of FieldNames

 

SaveFile

Takes two parameters, FileName, FileData

 

AppendQuery

Takes 3 parameters, DestinationQuery, SourceQuery, bMoveIt

 

[Ensure] Field Exists

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

 

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

Takes a variable number of conditional logical if statements

 

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.

 

Moxie.cfg Config

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

 

[HtmlOutput]

Takes a variable number of parameters

 

Select / Case / End Select

Takes a variable number of conditional statements to compare against a single source

 

ServerLog

Takes one parameter, ServerLogText

 

Cloudflare Origin Certificates

Cloudflare automatically provides free client-facing certificates for your domain, even when 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 when you are going to have Cloudflare connect to inbound open ports on your Moxie.Build server.