Re: Filling a dataset with random records

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

Date: Fri, 27 Aug 2004 16:28:19 -0700

Let's see the code you use to execute this query. 

-- 
____________________________________
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:BE8B4192-9DBD-47CF-8BDC-BC20E7AEF84D@microsoft.com...
>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
> when I test it out in Access.  Unfortunately, it does not work the same 
> way
> when I use it to configure my dataAdapter in VB.NET
>
> SELECT Problem
> FROM tblX
> WHERE (Skill = ?)
> ORDER By Rnd(ID)
>
> Any ideas?
>
> Thanks,
> Jennifer Yellman Quynn
> Motivational Assessment
> -- 
> Jennifer Yellman Quynn
> Motivational Assessment