Subject Re: [IBDI] Porting from MS SQL Server 7.0 to Interbase
Author hannes hernler
-----Ursprüngliche Nachricht-----
Von: Claudio Valderrama C. <cvalde@...>

>> 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?

hannes hernler
--------------------------------------------------------
DWS - Delphi Web Script
developing professional web apps
look at http://www.dwscript.com
--------------------------------------------------------