| Author |
Does Access support row id or rownum?
|
Satheesh karuppiah
Greenhorn
Joined: Dec 19, 2006
Posts: 1
|
|
I would like to get the records like (from 1st record to 20th record or 20-30) from access database. I wonder there is no support for rowid and rownum like oracle. Is there any way to retrieve the records like above?
Thanks in Advance.
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26184
|
|
Satheesh,
Welcome to JavaRanch!
As far as I know, Access doesn't support any easy way of doing paging. You could search for "access" and "paging" to confirm. (I haven't used Access, just read about it.)
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
 |
|
|
subject: Does Access support row id or rownum?
|
|
|
0
