Search Results for blank

 

[_$] Currency if not blank (Top Query)

Has no parameters. If the field is blank it will remain blank.

 

 

[_#] Format if not blank (Top Query)

Takes 1 parameter, a formatting mask

 

 

 

 

[_#] Format if not blank (DB Field Attribute)

Takes 1 parameter, a formatting mask

 

 

 

 

MergeRecords

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

 

Format

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

 

Children

Takes two parameters, ChildTableName, Mode

 

ChildrenAlias

Takes two parameters, ChildTableName, Mode

 

Delete

Takes two parameters, TableName and a boolean expression

 

NewTable

Takes two parameters, TableName, AutoAlias

 

Parents

Takes three parameters, ChildTableName, ParentTableName, Mode

 

ParentsAlias

Takes three parameters, ChildTableName, ParentTableName, Mode

 

Detach

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

 

Logout

Takes one parameter, SessionID

 

New

Takes two parameters, TableName, IfLenFld

 

Login$

Takes three parameters, Login, Password, bRememberMe

 

RawStream$

Takes one parameter, a top query destination variable

 

Similar%

Takes 2 parameters, pNum1, pNum2

 

JsonStream$

Has one parameter, Options

 

IsGroupType$

Takes two parameters: Username, GroupTypes

 

IsValidAlias$

Takes one parameter, a Source value

 

JsonEncode$

Has two parameters: Source, Options

 

Similar$

Takes 2 parameters, pString1, pString2

 

HtmlUpload

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

 

HttpCookie

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

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

HtmlSearchBox

Takes 6 parameters, Location, Mode, ActionPath, Name, Class, Prompt

 

TimeZone$

Takes two parameters, Source, Value

 

HtmlAButton

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

 

HtmlHistory

Takes two parameters, Title, Path

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

 

WithAll

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

 

WithGroup

Takes six parameters, FieldBase, GroupByField, Destination, Action, Source, IfLenFld

 

SSReference

A command to help build spreadsheets

 

SaveJsonFile

Takes two parameters, FileName, Options

 

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

 

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

 

HtmlTab

Takes 3 parameters, Location, Mode, bWithNoHeader

 

HtmlETable

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

 

XmlMerge

Takes two parameters, [WorkWith]+Scope, EmbedScope

 

HtmlDropdown

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

 

HtmlDTable

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

 

ResetFields

Takes two parameters, FieldBase, FieldNames

 

Group

Takes 7 parameters, FieldBase, GroupBy, GroupTotals, GrandTotals, Seperator, TotalPre, TotalPost

 

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

 

KeepIfAll

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

 

FixFields

Takes one parameter, a single character

 

Update

Takes two parameters, TableName, IfLenFld

 

Build

Takes a variable number of parameters

 

EnsureNavFields

Takes two parameters, FieldBase, FieldNamesList

 

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

 

PickFirstField

Takes three parameters, FieldBase, Destination, SourceFields

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

NewRecords

Takes one parameter, QuantityToAdd

 

KeepIfAny

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

 

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

 

Math

Takes a variable number of parameters

 

HttpSoap$

Takes 8 parameters, ServerName, Port, bSecure, Path, ExtraHttpHeaders, Envelope, ExtraBody, xml

 

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.

 

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.

 

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

 

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

 

[Raw] Raw HTML

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

 

AjaxReply

Has no parameters

 

Call

Takes a variable number of parameters

 

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.

 

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.

 

Soapbox Studios

Effective Websites. Downtown Quality, Small Town Affordability.

 

 

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.

 

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.

 

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.

 

 

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, Trigger, DestinationID, Path

 

Style Guide, Procedures and Code Documentation

In order for source code to be more readily readable across teams, it is recommended that your source code always be styled according to this style guide.

 

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.

 

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

 

CFPurge

Takes one parameter, the URL to purge from CloudFlare's cache

 

[ ? ] Pick First (Top Query)

Parameter is a space separated list of fields to choose from

 

CheckPw$

Takes two parameters, User and Password

 

[CountIf]

Takes one parameter, TestCondition

 

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.

 

Greg$

Takes one parameter, a gregorian number

 

Http$

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

 

Greg%

Takes one parameter, a date of the form yyyy-mm-dd

 

Dir$

Takes one parameter, a path-mask

 

GeoDistance$

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

 

Cloudflared Tunnel

Cloudflared Tunnel exposes applications running on your local web server on any network with an internet connection with an outbound tunnel that connects directly to Cloudflare's edge network without the need to configure inbound firewall rules.

 

PaaS

Takes three parameters, Url, SaaSTenant, InputQuery, OutputQuery

 

Prefix

Takes a single string as parameter, which is then appended to each line in the code block.

 

NewEComQuery

Takes one parameter, QueryName

 

[Ensure] Field Exists

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

 

Image

Has 5 parameters, DestFileName, Action, SrcFileName, Val1, Val2

 

[Reset]

Fields

 

Remote

Takes three parameters, Url, InputQuery, OutputQuery

 

[Pull] List of Fields from another Query

Takes three parameters, QueryName, FieldBase, FieldNames

 

Home

Web/API Development Platform with an in-memory database, native-code CMS, and a powerful runtime environment Whether you are a new startup taking off or optimizing your business model for growth, Moxie.Build provides a robust platform with a proven track record for marketplaces, eCommerce, and business process automation

 

Cloudflare Integration

Cloudflare is a first and foremost a Web Application Firewall and Content Distribution Network, among other additional services.

 

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.