How to fetch a Record randomlly using Random Function.

Comments

• Options

  Tim81 Member Posts: 68

  2005-06-16

  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.

  0
• Options

  fcassoli Member Posts: 16

  2005-06-16

  Maybe you can use NEXT?
  
  The code should look like this:

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

  
  Federico

  0