How do most people implement paged queries with Firebird. Is there any
support for Scrollable Recordsets? OFFSET and LIMIT?

Right now, all I can think of to do is to construct my sorting and filtering
criteria. Do a COUNT with that filter, then SELECT nRowSize * nPageNumber
records using the same criteria by setting the MaxRows and FectchSize. This
gets to be pretty horribly inefficient.

Thoughts?

R.