Filling a dataset with randomly chosen records

J

Jenny Yellman

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
 
V

Van T. Dinh

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.
 
Top