Last post Oct 23, 2011 02:13 PM by hans_v
Oct 22, 2011 09:26 AM|jasonsky|LINK
I am using ACCESS DB, I would like to select a random record row from my database. It doesn't work from the SQL statment I found "SELECT column FROM table ORDER BY
Any idea? Thanks.
Oct 22, 2011 11:49 AM|Mikesdotnetting|LINK
SELECT TOP 1 * FROM myTable ORDER BY Rnd(-10000000*TimeValue(Now())*[id])
Oct 22, 2011 07:42 PM|hans_v|LINK
It is a long time ago, but I remembered this thread, but when I read it again, I noticed something regarding another thing:
I know that a bunch of functions within Access are not supported by the Jet provider. If you try Replace() for example, you get a function not supported error. The way round this is to create a saved query and call that in the same way as a stored proc in SQL
This is not true. When executing saved queries, they can only contain functions that are supported in Jet, otherwise they will raise an error also.
Oct 23, 2011 09:45 AM|jasonsky|LINK
I tried. I have 16 records in database, but it keeps showing me 2 of the cords. Do you know what the problem is?
Oct 23, 2011 02:13 PM|hans_v|LINK
Do you know what the problem is?
Not if you don't show us what exactly you're doing?