Takes one parameter, FieldName
Takes up to three parameters, QueryName, FieldBase, FieldNames
Takes a single parameter, in the format of TableName.FieldName#Deff where Deff is one of: Label, Attr, Note, or DevNote
Takes two parameters, FieldBase, FieldNameList
Takes two parameters, a FieldBase and FieldNamesList
Parameter is a single new field name or a space separated list of new field names.
Parameter is a space separated list of field names to be displayed when the user is viewing results from the Search List.
Parameter is a space separated list of field names to be displayed.
Takes one parameter, a comma separated list of FieldNames
Takes two parameters, DestinationFields, SourceFields
Takes three parameters, FieldBase, OldFieldName, NewFieldName
Takes 4 parameters, FieldBase, Destination, SourceFields, Delimiter
Takes two parameters, FieldBase, FieldNames
Takes two parameters, FieldBase, FieldNames
Takes three parameters, FieldBase, Destination, SourceFields
Takes two parameters, FieldBase, FieldNamesList
Takes two parameters, FieldBase, FieldNames
Takes two parameters, FieldBase, FieldNamesList
Takes one parameter, FieldBaseToTrim
Takes one parameter, a FieldBase
Parameter is the table and field name that you want to sum in the form of TableName.FieldName. The specified Table must be a Child of the calling Record.
Takes one parameter, TableName
Takes one parameter, a single character
Takes one parameter, a Source value
Takes one parameter, Source value
Has no parameters
Takes a variable number of parameters, a comma separated list of TopQuery variable names
Takes no parameters
Has no parameters.
Has no parameters
Allows any extra HTML Attributes to be specified in the Control's HTML Tag
Parameter is the database path that is to be looked up in the form of TableName|Alias|FieldName where it may be a specific fixed path or you may use {} to replace one or more of the path components where the value inside the {} is a field name in the current record.
Used as a Relationship Attribute, the parameter is a space separated list of field names
Has no parameters.
Has no parameters.
Has no parameters.
Has no parameters.
Has no parameters.
Has no parameters.
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.
Takes 1 parameter, a formatting mask
Takes 1 parameter, a formatting mask
Takes one parameter, FieldBase
Has 5 parameters, DestinationQuery, SourceQuery, DestinationMatchField, SourceMatchField, Mode
Takes three parameters, QueryName, FieldBase, FieldNames
Takes one parameter, FieldName
Takes seven parameters, FieldBase, Destination, Source, bAny, Delimiter, Item, IfLenFld
Takes three parameters, FieldBase, Fields, IfLenFld
Takes two parameters, FieldBase, PivotField
Takes two parameters, WorkFieldBase + FieldToParse, Delimiter
Takes three parameters, FieldBase, Fields, IfLenFld
Takes one parameter, FieldBase
Takes one parameter, FieldBase
Takes 7 parameters, FieldBase, Destination, Source, OffsetVal, Operator, OpValue, IfLenFld
Takes 6 parameters, FieldBase, Destination, Function, Source, Value, IfLenFld
Takes 7 parameters, FieldBase, GroupBy, GroupTotals, GrandTotals, Seperator, TotalPre, TotalPost
Takes up to 6 parameters, FieldBase, FileName, Action, Val1, Val2, IfLenField
Takes 4 parameters, FieldBase, Left, Comparison, Right
Takes five parameters, FieldBase, FieldList, Mask, bBlanks2Zero, IfLenFld
Takes three parameters, TableName, SearchTerms, SearchInFields
Takes six parameters, FieldBase, Destination, Table, Alias, SourceField, IfLenFld
Takes 5 parameters, FieldBase, Destination, Action, Source, IfLenFld
Takes a variable number of parameters, FieldBase, Test1, Test2, [etc..]
Takes four parameters, FieldBase, Destination, Source, IfLenFld
Takes two parameters, WorkFieldBase, UniqueValueField
Takes 5 parameters, FieldBase, GroupBy, MergeField, Delimiter, bKeepBlanks
Takes 3 parameters, FieldBase, pOne, pTwo
Takes a variable number of parameters, FieldBase, Test1, Test2, [etc...]
Takes one parameter, in the form of: Table|{Alias}|Field
Takes 3 parameters, FieldBase, Fields, SearchTerms
Takes a single Field name, with an optional Not operator, followed by the conditional statement
Accepts a space separated list of field names.
Takes five parameters, FieldBase, Destination, Action, Source, IfLenFld
Parameter is a space separated list of field names to have the display table sorted by when displaying search results.
Has no parameters.
Takes two parameters, FieldName, FieldValue
Takes two parameters, FieldBase, SortFieldList
Takes six parameters, FieldBase, GroupByField, Destination, Action, Source, IfLenFld
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. 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 used with a Top Query in MOX, this will ensure the field value matches one of the options, if not it will throw a run time error.
Takes four parameters, FieldBase, Destination, Function, IfLenFld
Takes six parameters, FieldBase, Destination, Function, Source, Value, IfLenFld
Accepts one parameter which is the raw HTML content to be placed in the form, above the Field's location.
No parameters, provides a user friendly date picker as the input field for a given Field.
Has no parameters.
Accepts one parameter which is the raw HTML content to be placed in the form, below the Field's location.
Takes 10 parameters, FieldBase, From, To, Subject, Body, bMerge, AttachName, AttachPath, Slow, IfLenFld
Takes four parameters, FieldBase, Destination, Source, IfLenFld
Takes two parameters, FieldName, Value
Takes a single parameter, a FieldBase
Accepts one parameter which is the raw HTML content to be placed in the form at the Field's location.
Parameter must first specify only looking at Parents ( PARENT ) or only looking at Children ( CHILD ). The remainder of the parameter should be the table and field name you are after in the form of TableName.FieldName.
Takes one parameter which is the keyboard key which will be used as the Access Key for a given Database Table's field.
*Note: By default, each Field's Access Key will be initialized to the first character of the Field's Label.
Takes four parameters, FieldBase, Destination, Source, IfLenFld
Takes a variable number of parameters, FieldBase, Destination, Source, Test1, Test2, [etc...]
Takes a variable number of parameters, FieldBase, Destination, Source, Test1, Test2, [etc...]
Takes four parameters, FieldBase, Destination, Source, IfLenFld
Takes six parameters, FieldBase, Destination, Source, Left, Comparison, Right
Parameter is the database path that is to be looked up in the form of TableName|Alias|FieldName where it may be a specific fixed path or you may use {} to replace one or more of the path components where the value inside the {} is a field name in the current record.
Has no parameters. If the field is blank it will remain blank.
Takes two parameters, Location, Mode
Takes 5 parameters, Location, Mode, Title, Element, Class
Takes 6 parameters, Location, Mode, ActionLabel, ActionPath, Class, ActionMethod
Takes 10 parameters, Location, Mode, Title, TitleLink, Class, Fixed, bNotResponsive, bInverted, HtmlPre, HtmlApn
A database command which takes two parameters, TableName, IfLenFld
Takes no parameters
Takes 6 parameters, Location, Mode, Class, bNoHeader, bNoAutoAlign, bNoIDTags
Takes two parameters, ExcelTableData, Options
Used to manipulate a WorkQuery into a JSON type
Takes 7 parameters, Location, Mode, Title, TitleLink, Class, HtmlPre, HtmlApn
Takes a variable number of parameters
A command to help build spreadsheets
Takes two parameters, Data, bHasHeader
Takes two parameters, FileName, bHasHeader
Takes a variable number of parameters
Takes two parameters, FileName, bUseHeaders
Takes two parameters, FileName, Options
Takes two parameters, FileName, bUseHeader
Takes two parameters, FileName, bUseHeaders
Takes no parameters.
Takes one parameter, FilePath
Takes no parameters
Takes 3 parameters, Folder, Filter, bShowImgSize
Takes one parameter, Data
Takes two parameters, [WorkWith]+Scope, EmbedScope
Takes no parameters
Takes two parameters, Data, bHasHeader
Takes two parameters, FileName, bHasHeader
Takes two parameters, FileName, bHasHeader
Has no parameters
Takes three parameters, TableName, Alias, Password
Takes 3 parameters, Destination, Action, Source
Has no parameters
A special type of Private Method, called a Private Function, is intended to return a single value or multiple values simultaneously.
Takes a variable number of parameters, QueryName, MethodName, [Param1, [Param2, etc...]]
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.
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.
Takes 3 parameters, DestinationQuery, SourceQuery, bMoveIt
Has no parameters
Takes a variable number of conditional statements
Takes one parameter, QueryName
Used as a scoping keyword, similar to WorkWith/End WorkWith .
Takes a variable number of parameters.
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.
Takes one parameter, QueryName
Takes six parameters, DestQuery, SourceQuery, DestDestFld, DestXFld, DestYFld, SourceYFld
Has one parameter, a Content.Lang prefix
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.
Takes five parameters, DestQuery, SourceQuery, SourceXFld, SourceYFld, SourceZFld
Accepts a numeric value as a parameter.
Accepts a numeric value as a parameter.
Accepts one parameter
Accepts one optional numeric value as a parameter
Has no parameters.
Prerequisites: This tutorial assumes that you have already learned about Managing Files .
The MOX language pays heritage to BASIC, but has been crafted for the specific type of work and environment that is demanded of Moxie.Build.
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.
Takes 3 parameters, Trigger, DestinationID, Path
Has no parameters.
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 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.
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 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.
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.
Accepts 3 parameters, first is required, 2nd and 3rd are optional.
This hands-on experience article is written by an experienced PHP developer, and serves as an overview to help you understand the similarities and differences.
Takes one parameter.
Takes 6 parameters, Location, Mode, ActionLabel, ActionPath, Class, ActionMethod
Takes two parameters, Location, Mode
Takes 6 parameters, Name, Value, Path, Domain, Expires, Other
Takes seven parameters, Location, Mode, Prompt, Path, Class, Name, HelpText
Takes one parameter, a top query destination variable
Takes two parameters, Source , Search
Takes two parameters, Source , Search
Takes one parameter, bNoHeader
Takes one parameter, a Date value
Takes one parameter, a TableName
Takes 3 parameters, ParentTableName, ChildTableName, and a boolean expression (optional)
Takes three parameters, ChildTableName, ParentTableName, Mode
Takes two parameters, TableName, IfLenFld
Takes two parameters, TableName and a boolean expression
Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld
Takes one parameter, TableName
Takes two parameters, ChildTableName, Mode
Has no parameters
Takes no parameters
Takes one parameter, Message, or no parameters
Takes either one parameter, ResultValue, or no parameters
Takes no parameters.
Takes one parameter, TestCondition
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.
Takes either one parameter, ResultValue, or no parameters
Takes one parameter bNoHeaders and returns the result to an assigned variable
Takes one parameter, Message, or no parameters
Has one parameter, Options
Takes no parameters