Thanks a lot Set...
--- In [email protected], Svein Erling Tysvær
<svein.erling.tysvaer@...> wrote:
>
> >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
>
