Filling a dataset with randomly chosen records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
The Rnd() function is only available if you run the SQL in Access, not from
outside.

Sorry, don't know enough of VB.Net to advise. Suggest you re-post in one of
the VB.Net newsgroups.
 
Back
Top