>Hi,
>
>I have tables in my Firebird database with over 100000 records with out primary key
>(I have primary key made from 3 fields) and I can't read data between first and second
>key because it is a large amount of data.
>So is there any solution in firebird to read for example first 1000 rows, next 1000
>rows, next...

Don't know if I understood your question. Is the answer as simple as

SELECT *
FROM <table>
ROWS :a to :a+999

HTH,
Set