Hmmm...in that case you will probably have to do a count query to get the total records, then perform the query and use the page number and size to skip ahead in the resultset. I suppose you could use a temp table and generate the row numbers, but I'm not sure that would be any better than just moving the cursor ahead to the rows in the current page.

R.

-----Original Message-----
From: javier_castanon [mailto:javier_castanon@...]
Sent: Fri 3/21/2003 4:50 PM
To: ib-support@yahoogroups.com
Cc:
Subject: [ib-support] Re: Strategies for resultset paging



"Robert DiFalco" <rdifalco@t...> wrote:

> Doesn't interbase have the ROWS nStart TO nEnd option in 6.5?

I've just checked the documentation, and it is not included, at least
in version 6, that's the version we're tied to :-(

Javier



[Non-text portions of this message have been removed]