> can you then suggest solution if I have table with let say 100,000
> records and I want to display record 50,000 - 50,010? How to do it
> effectively and fast?

The easiest would be SELECT FIRST 10 SKIP 50000 * FROM myTable, but
that would cause server to fetch first 50,000 records and just throw
them away. The most effective would be - do not use such feature until
Firebird provides scrollable cursors. Most likely your table has some
key (surrogate PK, timestamp, etc), use SELECT * FROM myTable WHERE
myFilterField BETWEEN ? AND ?, in this case server can use index. This
would be the most effective for big result sets.

(BTW, you can submit your desire to have them into Firebird-Architect
group, there's still no consensus among developers whether to try to
implement this feature or not).

Roman