Re: Nothing is random

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 16:32:53 -0700

Jenny, it's bad form to ask the same question over and over again using
different subjects. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Jenny Yellman" <jaquynn@ihmail.com.donotspam> wrote in message 
news:C219B252-ABD6-49CD-AD0E-1D3B34DADC6C@microsoft.com...
> 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
>

Relevant Pages

  • Nothing is random
    ... The following SQL statement works perfectly well in Access, ... WHERE (Skill = ?) ... 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)