Category: Functions

Reads a text file containing a JSON structure and places its compressed contents in a variable. Syntax $getjson(<a variable>, <a document name>) Parameters a variable a variable, a field name or a form field name receiving the contents of the document a document a valid Zim:X document name pointing to a JSON structured text file…
Read more

Finds data within a JSON record using selection criteria. Syntax $findjson(source, argument-1, argument-2, …, argument-n) Parameters source a field, a variable, a form field or a constant containing a JSON structure argument-1 selection criteria to be searched within the specified source argument-2 secondary selection criteria to be searched within the result just found by the previous selection…
Read more

A temporary file system path where ZIMQTC stores intermediate files and caching information. Return Value A character string. Cannot be reset by an application program. Description This file path usually points to the Users directory (locally) in the client machine and is accessible by the user running ZIMQTC as the sole owner of the files therein.…
Read more

The function $escapeXML translates the parameter looking for characters that might disrupt a XML output. Syntax $EscapeXML(expression) Parameters expression an expression that evaluates to a string Return Value A character string translated according to XML standards. Example OUT $ESCAPEXML(“ab<cd”) ab<cd See Also SET OUTPUT FORMAT XMLSIMPLE SET XML ROWELEMENT SET XMLHEADER

Returns the number of members in a result set. Syntax $lastmember(setname) Parameters setname A character string or an expression that evaluates to a character string, being the name of a result set. Return Value Number with no decimal places. Comments $lastmember returns the (numerical) position of the last member in the specified result set (in…
Read more

Centers a non-blank character string. Syntax $center(string) | $centre(string) Parameters string a character string, or an expression that evaluates to a character string Return Value Character string, consisting of string centered in a space $length(string) characters long. Leading or trailing blanks in string are ignored during centering. If string contains an odd number of characters,…
Read more

Calculates a date value by adding months to (or subtracting months from) a specified date value. Syntax $addmonths(date,number) where date a date, or an expression that evaluates to a DATE data type number a number, or an expression that evaluates to a number Return Value Number, representing a DATE value. Comments Use $addmonths to perform…
Read more

Generates a pseudo-random number, uniformly distributed within the range 0 to 1. Syntax $random(number) Parameters number a number, or an expression that evaluates to a number, that acts as a seed for the random number generator Return Value Number, with the same number of decimal places as number. Comments Use $random to generate a series…
Read more

Extracts a segment from the end of a character string. Syntax $right(source,length) Parameters source a character string, or an expression that evaluates to a character string length a number, or an expression that evaluates to a number Return Value Character string, consisting of length characters from source, starting length character positions from the end of…
Read more

Returns the unique values from a series of successive values. Syntax $distinct(expression) Parameters expression any expression Return Value This function returns the unique values from a series of successive values. For each instance of its argument, $distinct returns a value that depends on the immediately previous value of the argument. If the previous and current…
Read more