Specifications

Rand
728 InfoMaker
Rand
Description Obtains a random whole number between 1 and a specified upper limit.
Syntax Rand ( n )
Return value A numeric datatype, the datatype of n. Returns a random whole number
between 1 and n.
Usage The sequence of numbers generated by repeated calls to the Rand function is a
computer-generated pseudorandom sequence.
Examples This expression returns a random whole number between 1 and 10:
Rand(10)
Real
Description Converts a string value to a real datatype.
Syntax Real ( string )
Return value Real. Returns the contents of a string as a real. If string is not a valid number,
Real returns 0.
Examples This expression converts 24 to a real:
Real("24")
This expression returns the value in the column temp_text as a real:
Real(temp_text)
Argument Description
n The upper limit of the range of random numbers you want returned.
The lower limit is always 1. The upper limit cannot exceed 32,767.
Argument Description
string The string whose value you want to convert to a real