Nothing is random

From: Jenny Yellman (jaquynn_at_ihmail.com.donotspam)
Date: 08/27/04

  • Next message: Andy DF: "Updating to MDAC 2.8" 
    Date: Thu, 26 Aug 2004 19:33:04 -0700

    How do I write a SQL statement so that the dataset will be filled with
    randomly chosen records?

    The following SQL statement works perfectly well in Access, but not when
    configuring my dataadapter in VB.NET.

    SELECT Problem
    FROM tblX
    WHERE (Skill = ?)
    ORDER BY Rnd(ID)

    In VB.NET the above appears to fill the ds randomly, but it is the same set
    of records every time I run the program.

    Thank you for your help. 

    -- 
Jennifer Yellman Quynn
Motivational Assessment
  • Next message: Andy DF: "Updating to MDAC 2.8"

    Relevant Pages

    • Re: Nothing is random
      ... Jenny, it's bad form to ask the same question over and over again using ... > The following SQL statement works perfectly well in Access, ... > Jennifer Yellman Quynn ...
      (microsoft.public.data.ado)
    • Filling a dataset with random records
      ... I am filling a dataset in VB.NET with randomly chosen records from a table in ... an Access Database. ... I use the following SQL statement that works perfectly ... Jennifer Yellman Quynn ...
      (microsoft.public.data.ado)