How to fetch a Record randomlly using Random Function.

Madhan

hi

I like to know that, how to fetch a records randomlly using Random Function with Arrays.

Right now, i had created Question Bank Report. In that i am have a set questions.so, when i fetch the records, it should come randomlly.

can any one help me....how to do this.....

Its very urgent.

Regards
Madhan.

Tim81

Hi,

i think one possibility is this.

The records need an id. The numbers of the id have to be continuous. If you cant grant this, cause of a setrange for example, write the records in a temporary table with continuous ids.

Then use following code (QuestionBank represents your record with the questions):

RANDOMIZE();
No := RANDOM(QuestionBank.COUNT);

//if 'No' is Primary Key
QuestionBank.GET(No); 

// if 'No' is just another field where you want to use SETRANGE
QuestionBank.SETRANGE("Entry No.",No); // or similar

You needn't to use the RANDOMIZE function before every call of RANDOM. But it generates a set of random numbers, so you should use it on and off.

Maybe there is a better solution. Haven't worked with RANDOM often so far.

fcassoli

Maybe you can use NEXT?

The code should look like this:

QuestionBank.find('-');
QuestionBank.next(RandomNumber);

Federico