Random Number

madm · 2007-08-16

I have managed to create a "random" number field, simply by

RANDOMIZE;
RndmNumber := RANDOM(12);

Which gives me a number between 1 and 12. How do I give it a minimum? ( I only want 8 - 12) ?

Thanks

Sunset · 2007-08-16

You can't do minimum but ...

RndmNumber := RANDOM(4) + 8 should do nicely

madm · 2007-08-16

Sunset wrote:

You can't do minimum but ...

RndmNumber := RANDOM(4) + 8 should do nicely

yours was the easy approach lol

i came up with a long way, not sure if its acceptable?!

IF RndmNumber <8 THEN
REPEAT
RANDOMIZE;
RndmNumber := RANDOM(12);
UNTIL RndmNumber >7;

jlandeen · 2007-08-16

I completely agree with sunset's approach.

I've found in the past that Navision's random number generator is not as "random" as I would have expected. This could mean that you're loop may end up repeating too many times if there are a lot of random numbers generated that are less then or equal to 7.

DenSter · 2007-08-16

Sunset wrote:

You can't do minimum but ...

RndmNumber := RANDOM(4) + 8 should do nicely

=D> =D>
Excellence in simplicity, I like that one

kine · 2007-08-17

This way to generate numbers is very similar in all languages. Some languages had just random generator generating numbers between 0 and 1. It means, if you wanted to have numbers from range 10..90 you needed to do

I := RANDOM*80+10;

8)

madm · 2007-08-17

thanks

i did think that the loop may end up looping continually if the random number never went over 7!!

So went for

RANDOM(5) + 7; (so that 8 is given a chance)!

btilman · 2011-12-02

So how can I get this code into a Text field

Sunset · 2011-12-06

btilman wrote:

So how can I get this code into a Text field

The easy way round this would be to use FORMAT.
Have a function create the random number you want, and then FORMAT(Number)

Howdy, Stranger!

Quick Links

Categories

Random Number

Answers