Returns information about the currently accessed application directories. Syntax $dirpath() Return Value Character string. Comments $dirpath returns a character string consisting of the names of all currently accessed application directories and their access types (U for update, R for read). Information about each directory is enclosed in semicolons (;). The directory name appears first, followed…
Read more
Calculates a time value by adding minutes to (or subtracting minutes from) a specified time value. Syntax $addminutes(time,number) where time an 8-digit number or an expression that evaluates to an 8-digit number, that expresses a valid time value in the format HHMMSSTT number a number or an expression that evaluates to a number Return Value…
Read more
Calculates a time value by adding seconds to (or subtracting seconds from) a specified time value. Syntax $addseconds(time,number) Parameters time an 8-digit number, or an expression that evaluates to an 8-digit number, that expresses a valid time value in the format HHMMSSTT number a number, or an expression that evaluates to a number Return Value…
Read more
Counts the number of set members that meet a specified condition, excluding records in which the condition is $Null. Syntax $count(expression) Parameters expression is any expression Return Value Number, with no decimal places. Comments Expression is often a WHERE expression that includes only selected set members in the counting operation. If the WHERE expression (expr1…
Read more
Converts a value into its numeric equivalent. Syntax $tonumber(expression,decimals) Parameters expression Any value, or an expression that yields any value. decimals A number specifying the number of decimal places required in the converted value. Decimals can be negative. Return Value Number equivalent of expression. Comments Use $tonumber to obtain the numeric equivalent of expression. If…
Read more
Returns the minimum value of a set of values. Syntax $min(expression) Parameters expression any expression Return Value The value of the selected instance of expression. Comments Use $min to find the smallest value among members of a set. Instances of expression that are $Null are ignored. Expression is often a WHERE expression that includes only…
Read more
Returns the maximum value of a set of values. Syntax $max(expression) Parameters expression any expression Return Value The value of the selected instance of expression. Comments Use $max to find the largest value among members of a set. Instances of expression that are $Null are ignored. Expression is often a WHERE expression that includes only…
Read more
Returns the average value of a set of values, excluding $Null values. Syntax $average(expression) Parameters expression any expression Return Value Number, with the number of decimal places implied by expression. Comments The function calculates the average of a set of values, excluding $Null values. Expression is often a WHERE expression that includes only selected values…
Read more
Builds a single character string out of separate strings, inserting a separator string. Syntax $squeeze(separator «,string») Parameters separator A character string, or an expression that evaluates to a character string. Separator is placed between each instance of string. string A character string, or an expression that evaluates to a character string. Leading and trailing blanks…
Read more
Calculates a date value by adding weeks to (or subtracting weeks from) a specified date value. Syntax $addweeks(date,number) Parameters 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 $addweeks to perform…
Read more
English 
Portuguese