On 19 Dec 2004 at 22:13, william_yuwei wrote:

> I have a 20 rows grid that I just want to implement "fetch data on
>demand" for it, that is I only want to fetch 20 rows data from server
>until the grid is scrolled, then fetch another 20 rows, so what should
>I do implement this purpose at SQL level (back end)?

No need to implement anything at SQL level. If you need only 20
rows - fetch only 20 rows (issue isc_dsql_fetch() 20 times).
Depending on what you use for getting data, you may have to set
FullFetch property to false.
--
SY, Dimitry Sibiryakov.