Filling a dataset with randomly chosen records

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

Date: Fri, 27 Aug 2004 16:13:05 -0700

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

Relevant Pages

  • Configuring a dataAdapter with a SQL statement
    ... I am filling a dataset in VB.NET with records from an Access database. ... want to fill the dataset with randomly chosen records. ... 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)
  • Re: how do you update a java.sql.date type in an ms access database
    ... > when i update a row in an access database the date field ... DateTime data type in Access/Jet is more like a java.sql.Timestamp. ... Well, partly, but you're not using the date AS a date in the SQL statement, ... but as a String. ...
    (comp.lang.java.help)
  • Re: Editing foreign key names in MS Access
    ... You can change the name of foreign keys. ... I could change it programmatically or via an SQL statement using ... ALTER TABLE, however I am looking for a simple GUI method to do this ... (i.e. something within the standard MS Access database application). ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Database Listing and Sorting
    ... I am a rookie and just filling in) ... > I was wondering if someone could give some quick advice on how to modify the ... > This is coming from an Access database using ODBC so the 'GetRecord' ... > shorten the display. ...
    (microsoft.public.vc.database)