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. This can be an INT64 value.
high: An integer expression that is the higher of the two expressions you are supplying to the RANDOM function. This can be an INT64 value.

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.

r-random.p

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.