meta data for this page
  •  

F_INTRANDOM

function from adhoc

Entrypoint intrandom compatible with UTF-8

Inputs/Outputs

   Input     INTEGER       min. value of random-no.
             INTEGER       max. value of random-no.
   Output    INTEGER       integer-random-no. with value between parameter 1 and parameter 2

Syntax

   This function can create more than one different random-no. in one second because the generator is set with the actual systemtime 
   and the process-ID, so that is is impossible, that 2 calls in the same second return the same random-no.
   TestSQL
   SELECT F_INTRANDOM(100, 10000) FROM RDB$DATABASE;
   SELECT F_INTRANDOM(NULL, NULL) FROM RDB$DATABASE;