Previous Next

RANDOM function
Returns a random INTEGER value between two integers (inclusive).
Note:
This function returns a number from a pseudorandom sequence of numbers rather than a truly random sequence.
The Alternate Random Number Generator (-rand) parameter determines whether the same sequence of random numbers is generated for each session. For information on this parameter, see OpenEdge Deployment: Startup Command and Parameter Reference.
Syntax 
 
RANDOM ( low , high )
low
An integer expression that is the lower of the two expressions you are supplying to the RANDOM function.
high
An integer expression that is the higher of the two expressions you are supplying to the RANDOM function.
Example 
Often when you set up a database for testing purposes, you want to generate many records without actually keying in data for each record. The r-random.p procedure generates 10 Order records and a random number of OrderLines for each Order record.
 
DEFINE VARIABLE onum  AS INTEGER NO-UNDO.
DEFINE VARIABLE olnum AS INTEGER NO-UNDO.
 
DO onum = 1 TO 10 TRANSACTION:
  CREATE Order.
  ASSIGN
    Order.OrderNum  = onum
    Order.OrderDate = TODAY.
 
  DO olnum = 1 TO RANDOM(1,9):
    CREATE OrderLine.
    ASSIGN
      OrderLine.LineNum = olnum
      OrderLine.ItemNum = olnum.
  END.
END.

Previous Next
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.