Performs a Boolean XOR of two logic expressions. Syntax expression1 XOR expression2 Parameters expression1 Any conditional expression or Boolean expression. If the expression is complex, it must be enclosed in parentheses. expression2 Any conditional expression or Boolean expression. If the expression is complex, it must be enclosed in parentheses. Return Value Logical as follows: Truth…
Read more
Compares two expressions and returns a value of “true” or “false”. Syntax expression1 = < <= <> > >= expression2 Parameters expression1 any value expression expression2 any value expression Return Value Logical Comments In a conditional expression, the less than sign (<) compares the expressions to its left and right, and is logically true if…
Read more
Invokes and interacts with DDE services Syntax $DDEFunction ( p1, p2, p3, p4, … ) Parameters p1 return type, longint p2 command, longint p3 server handle, longint p4 application command, string Comments Where p1, p2, and so on, indicate the desired DDE service and the data required by that service. The first parameter, p1, is…
Read more
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
English 
Portuguese