Hmmm... I realize its been a while since I've read Derby's manual, but doesn't Derby support Scrollable cursors?
A scrollable cursor will allow you to run a query and to fetch specific rows from the result set. At a minimum, that is what Sergey is originally asking and which is supported by multiple RDBMSs. > -----Original Message----- > From: Fantry, John [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 09, 2006 10:00 AM > To: Derby Discussion > Subject: RE: Results portion > > > This question has bean asked several times already . . . Once by me ;-) > The answer is NO. There is no way to retrieve rows in this fashion. I > had to create an extra "index" column in my table in order to simulate > this kind of behavior. Big pain in the . . . > > > -----Original Message----- > From: Sergey Zolotaryov [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 09, 2006 7:43 AM > To: [email protected] > Subject: Results portion > > Is there a way to retrieve a portion of results using Derby? For > example, I want to get rows from 10 to 20 from a resultset. All dbs I > know of, have this feature, smth like "LIMIT n, m" , or "ROWS n TO m". > Also is there a way to retrieve the total number of rows in last > select? > Thank you. > > **************************************************************** > The information transmitted in this message is confidential and may be > privileged. Any review, retransmission, dissemination, or other use of > this information by persons or entities other than the intended recipient > is prohibited. If you are not the intended recipient, please notify > Analogic Corporation immediately - by replying to this message or by > sending an email to [EMAIL PROTECTED] - and destroy all copies > of this information, including any attachments, without reading or > disclosing them. > > > Thank you.
