This section describes functions for mathematical constants and Boolean values. These functions do not have any parameters, but the parentheses are still required.
All functions can be used in both the data load script and in chart expressions.
The function returns a random number between 0 and 1. This can be used to create sample data.
This example script creates a table of 1000 records with randomly selected upper case characters, that is, characters in the range 65 to 91 (65+26).
Load Chr( Floor(rand() * 26) + 65) as UCaseChar, RecNo() as ID Autogenerate 1000;