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 (DB Field Attribute)

Takes 1 parameter, a formatting mask

 

 

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

Takes 1 parameter, a formatting mask

 

 

 

 

MergeRecords

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

 

Format

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

 

[!] 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. To use different values than labels, for each comma separated pair, specify the value first inside of { } followed by the label.

If the Parameter is just the single word Checkbox, then instead of a drop down list with values, the user will be given a single checkbox: If the field is unchecked the value will be blank, and if it is checked the value will be "y".

When this attribute is used with a Top Query in MOX, it will ensure the field value matches one of the options; if not, it will throw a run time error.

 

HttpCookie

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

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

Children

Takes two parameters, ChildTableName, Mode

 

HtmlDTable

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

 

HtmlHistory

Takes two parameters, Title, Path

 

HtmlUpload

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

 

ChildrenAlias

Takes two parameters, ChildTableName, Mode

 

New

Takes two parameters, TableName, IfLenFld

 

NewTable

Takes two parameters, TableName, AutoAlias

 

Parents

Takes three parameters, ChildTableName, ParentTableName, Mode

 

Delete

Takes two parameters, TableName and a boolean expression

 

Detach

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

 

Logout

Takes one parameter, SessionID

 

Login$

Takes three parameters, Login, Password, bRememberMe

 

RawStream$

Takes one parameter, a top query destination variable

 

Similar%

Takes 2 parameters, pNum1, pNum2

 

IsValidAlias$

Takes one parameter, a Source value

 

JsonEncode$

Has two parameters: Source, Options

 

JsonStream$

Has one parameter, Options

 

Similar$

Takes 2 parameters, pString1, pString2

 

HtmlNav

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

 

HtmlAButton

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

 

HtmlETable

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

 

HtmlTab

Takes 3 parameters, Location, Mode, bWithNoHeader

 

TimeZone$

Takes two parameters, Source, Value

 

HtmlNavbar

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

 

SSReference

A command to help build spreadsheets

 

SetIfAny

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

 

Math

Takes a variable number of parameters

 

KeepIfAny

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

 

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

 

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

 

SetIfAll

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

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

ResetFields

Takes two parameters, FieldBase, FieldNames

 

SaveJsonFile

Takes two parameters, FileName, Options

 

NewRecords

Takes one parameter, QuantityToAdd

 

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

 

PickFirstField

Takes three parameters, FieldBase, Destination, SourceFields

 

Build

Takes a variable number of parameters

 

EnsureNavFields

Takes two parameters, FieldBase, FieldNamesList

 

FixFields

Takes one parameter, a single character

 

ParentsAlias

Takes three parameters, ChildTableName, ParentTableName, Mode

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

Update

Takes two parameters, TableName, IfLenFld

 

HtmlDropdown

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

 

KeepIfAll

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

 

WithGroup

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

 

WithAll

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

 

Group

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

 

XmlMerge

Takes two parameters, [WorkWith]+Scope, EmbedScope

 

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

 

IsGroupType$

Takes two parameters: Username, GroupTypes

 

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.

 

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.

 

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.

 

[Raw] Raw HTML

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

 

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

 

CFPurge

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

 

[Ensure] Field Exists

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

 

AjaxReply

Has no parameters

 

Soapbox Studios

Effective Websites. Downtown Quality, Small Town Affordability.

 

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.

 

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.

 

 

[Ajax]

Takes 3 parameters, Trigger, DestinationID, Path

 

 

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.

 

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.

 

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.

 

Image

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

 

CheckPw$

Takes two parameters, User and Password

 

Dir$

Takes one parameter, a path-mask

 

[ ? ] Pick First (Top Query)

Parameter is a space separated list of fields to choose from

 

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

 

[CountIf]

Takes one parameter, TestCondition

 

Http$

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

 

HttpSoap$

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

 

Greg$

Takes one parameter, a gregorian number

 

GeoDistance$

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

 

Greg%

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

 

[Pull] List of Fields from another Query

Takes three parameters, QueryName, FieldBase, FieldNames

 

Remote

Takes three parameters, Url, 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

 

PaaS

Takes three parameters, Url, SaaSTenant, InputQuery, OutputQuery

 

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.

 

Moxie.cfg Config

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

 

[Reset]

Fields

 

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.