Difference between revisions of "RAND()"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
Numeric Data | Numeric Data | ||
| Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[ | + | [[GETPID()]], [[TMPNAM()]], [[SET COMPATIBLE]], [[SYS()]] |
==Description== | ==Description== | ||
| − | The RAND() function returns a | + | The RAND() function returns a number in the range 1 to 2147483647. Subsequent calls to RAND() will produce different numbers, but the sequence of numbers will be the same each time. |
| + | |||
| + | With SET COMPATIBLE set to FOXPRO | FOXBASE | VFP the number range is between 0 and 1 and a seed can be specified in <expN>. Using the same positive value in <expN> and omitting it in subsequent calls to the RAND() function will return the same sequence of numbers. Using a negative value in <expN> creates a seed based on the system clock, so subsequent RAND() calls will produce a different sequence of values. | ||
| Line 26: | Line 25: | ||
? rand() | ? rand() | ||
31466 | 31466 | ||
| + | |||
| + | set compatible to foxpro | ||
| + | ? rand(-1) | ||
| + | 0.66 | ||
| + | ? rand() | ||
| + | 0.73 | ||
</code> | </code> | ||
| Line 33: | Line 38: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Numeric Data]] | ||
| + | [[Category:Numeric Data Functions]] | ||
Revision as of 09:10, 2 June 2009
Class
Numeric Data
Purpose
Function to return a random number
Syntax
RAND(<expN>)
See Also
GETPID(), TMPNAM(), SET COMPATIBLE, SYS()
Description
The RAND() function returns a number in the range 1 to 2147483647. Subsequent calls to RAND() will produce different numbers, but the sequence of numbers will be the same each time.
With SET COMPATIBLE set to FOXPRO | FOXBASE | VFP the number range is between 0 and 1 and a seed can be specified in <expN>. Using the same positive value in <expN> and omitting it in subsequent calls to the RAND() function will return the same sequence of numbers. Using a negative value in <expN> creates a seed based on the system clock, so subsequent RAND() calls will produce a different sequence of values.
Example
? rand() 31466 set compatible to foxpro ? rand(-1) 0.66 ? rand() 0.73
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
