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…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
Generates the “sounds-like” value of a string. Syntax $soundex(source) Parameters source a character string, or an expression that evaluates to a character string Return Value Character string (alpha). Comments $soundex yields a “sounds-like” value for source. The value is created using an heuristic algorithm and is based on English pronunciation. When $soundex is applied to…
Leia mais
Copies files from the client side to the server side. Syntax $copytoserver(source file name, destination file name, file type) where source file name an expression that evaluates to a character string containing a valid file address destination file name an expression that evaluates to a character string containing a valid file address file type an…
Leia mais
Returns the position of the current member of a result set. Syntax $currentmember(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 $currentmember returns the (numerical) position of the current member within the specified result…
Leia mais
Converts an ordinal number into a character. Syntax $tochr(number) Parameters number a number, or an expression that evaluates to a number Return Value Each of the decimal numbers from 0 to 255 represents a character output by your workstation. $tochr converts a given number to the corresponding character. Note: The ascii character 0 returns an…
Leia mais
Portuguese 
English