Subject | Re: [IBDI] Porting from MS SQL Server 7.0 to Interbase |
---|---|
Author | hannes hernler |
Post date | 2000-06-25T10:44:36Z |
-----Ursprüngliche Nachricht-----
Von: Claudio Valderrama C. <cvalde@...>
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
--------------------------------------------------------
Von: Claudio Valderrama C. <cvalde@...>
>> 2. Interbase does not support the TOP extension to SELECT, as inhey that would be great! in web apps I need a function like this very often.
>> 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.
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
--------------------------------------------------------