Feature Rich
Rapid Application Development
Helping you or your customers
Manage their Business

All pages rendered on the system use UDB commands to insert different elements on to the page.
For example, if you want to put the page title onto a template then you can insert the command {PAGE_TITLE}. This will be replaced with the current page title whatever page is being displayed.
If you want to add a link to a another page on the system then you can add {LINK(1013, Contact)}. This will create a link to the page number 1013 and add the text "Contact" (Contact).

All of the commands need to be enclosed in { } when used on the page and the command needs to be entered in upper case. They may also have parameters. These are enclosed in ( ). Most of the time it is easier to enter the parameters by position separated by commas. So in the LINK example above, the first parameter is the Object ID of the page you want to link to and the second parameter is the text you want to be displayed on the page. Sometimes there may be a larger number of parameter options and using lots of commas to get to the correct parameter can be awkward and confusing to read. In this case, you can use a JSON list of parameters. So for the example above, you can use {LINK(1013, {"text":"Contact","class":"btn btn-primary"})}. The JSON list of parameters can only be used as the last parameter. A list of all the parameters are detailed in the command help.

You can also pass in an array of parameters using an array variable. To do this add a JSON parameter "param_array":"V_ARRAY". All the values in the V_ARRAY variable will be used as parameters.

When adding an Object ID as a parameter, it is a good idea to precede it with "#:". This helps the system to identify the number as an Object ID. This is essential if you are writing an application to be shared by other organisations as the Object IDs will need to be changed by the system when they import your application. So the example above, should be written {LINK(#:1013, Contact)}. See OBJ_ID for more info.

If a parameter includes a comma it must be quoted {LINK(1013, "Contact John Doe or, a member of the team")}. If the parameter includes quotes and commas, quotes are escaped with another quote {LINK(1013, "Contact John ""The Man"" Doe or, a member of the team")}. 

Parameter values are individually interpreted before they are passed to the command for processing. This can be prevented by preceeding the parameter value with two exclamation marks!!

See below for a full list of commands and their explanations.

Page 1 of 1
Name Description Structure
ALPHA_INC Increase the value of an Alpha Numeric string {ALPHA_INC(val)}
ASCII Returns the ASCII value of the first character in a string {ASCII(char)}
ASTRING_APP Append a Key:Value Pair to the beginning of a Key:Value pair string {ASTRING_APP(string, key, val)}
ASTRING_CREATE Return a String of elements in a list [1:A,2:B,3:C] {ASTRING_CREATE(query, part}
ASTRING_PRE Prepend a Key:Value Pair to the beginning of a Key:Value pair string {ASTRING_PRE(string, key, val)}
BSWAP Swap individual characters in a string {BSWAP(string, search, replace)}
CHAR Return a series of characters specified by their ascii value {CHAR(...)}
CRLF Returns Carriage return & Line Feed characters {CRLF}
CROP Remove characters from the beginning and end of a string if there. {CROP(string, chars)}
ENCRYPT Encrypt a string of characters {ENCRYPT(txt, key)}
HASH Provide a hash of a character string {HASH(string, method)}
HASH_MATCH Used to check a string against a UDB hash value {HASH_MATCH(check, hash)}
HMAC_HASH Generate a keyed hash value using the HMAC method {HMAC_HASH(alg, data, key)}
INIT Return the Initials of a Character String {INIT(string)}
LCASE Change a Character String to Lower case {LCASE(string)}
LEFT Left n Characters if a String Character String {LEFT(string, length)}
LEN Return the length of a Character String {LEN(string)}
LINE Return a single line from a multi line string {LINE(string, line)}
MID Return a number of characters from a specified position in a String {MID(string, start, length)}
OCCURS Return the number of times a string exists within another {OCCURS(string, search)}
OPT_LIST_ADD Add a value to a list of items in a string {OPT_LIST_ADD(string, val)}
PAD_RIGHT Pad a string of characters to the right with additional characters {PAD_RIGHT(string, qty, char)}
QUERY_FIX Fix a string ready to be used in a query {QUERY_FIX(string)}
REG_ADJ Adjust text based on regular expression match {REG_ADJ(type, expression, adjustment, context)}
REG_MATCH Matches a string against a regular expression {REG_MATCH(string, pattern, name)}
REG_REP Performs regex replacement using the submitted list or regular expression {REG_REP(list_id, string)}
REPEAT Repeat a string of characters n times. {REPEAT(string, qty)}
REPLACE Replace all occurrences of the search string with the replacement string {REPLACE(string, search, replace)}
REV Reverse the letters in a Character String {REV(string)}
RIGHT Return the right n characters from a character string {RIGHT(string, length)}
SPLIT Split a string by a value and place the results in an array variable {SPLIT(string, search_string, name)}
STRPOS Return the position of one string within another starting from the left. {STRPOS(string, search)}
STRRPOS Return the position of one string within another starting from the right. {STRRPOS(string, search)}
TCASE Change the first character of each word to upper case {TCASE(string)}
TITLE Intelligently change the first character of each word to upper case {TITLE(string)}
TRIM Trim Spaces from the beginning, middle and end of a Character String. {TRIM(string)}
UCASE Change a Character String to Upper case {UCASE(string)}
XML_TAG Generate an XML element with a value {XML_TAG(name, value)}