Re: [Firebird-odbc-devel] Firebird Latest Odbc "SELECT TOP"

[Kjell R. <kje...@da...>]

Den 2011-04-15 09:23 skrev Alexander Potapchenko såhär:
> On 15.04.2011 11:11, Mig/ wrote:
>> We are porting to firebird some databases, some ODBC applications
>> does not work because "SELECT TOP" does not work, there is a workaround?
>> Since we are not able to change those application but only databases.
>>
>> Thanks
>>
>> --
>> Regards,
>> MIG
>>
>
> "SELECT TOP" is not standard sql. That is a typical Microsoft only feature.
> Always, when you migrate from one system to another you have to make
> sure, that your software is only using SQL commands, that are defined in
> the SQL standard.

If I'm not mistaken the SQL standard now includes the rows clause:

select *
from table
rows 1 to 20

Not sure about odbc etc and I don't think SQL Server supports rows, but 
FB 2.5 does.

Kjell
-- 
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kj...@da...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64