Hannes,

> >> 2. Interbase does not support the TOP extension to SELECT, as in
> >> SELECT TOP 10 * FROM PRODUCTS. This is needed by some 3rd party
> >> libraries we are using.
> >
> >Interbase DOES support it. The only problem is several functionality does
> >not appear in the DSQL interface, but it's here. It's a matter to enhance
> >the DSQL parser.
>
> hey that would be great! in web apps I need a function like this very often.
>
> and that is a question that I wanted to ask for long time:
> how would you implement this now?
> SELECT * FROM PRODUCTS and fetch only first 10 rows?

if your aim is to fetch only a certain amount of rows at a time, having
the chance to request the remaining rows as appropriate, then I believe
the subject of this thread is not what you are searching for. Tools
exist that let you do this programmatically in a very efficient way (I
could think of Delphi's ClientDataSet and IBO in the first place).
Actually, I can hardly see a use for "select top n" clauses, but if
people use it and the engine already supports it...
--
____
_/\/ando