firebird-odbc-devel

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

[Mig/ <mig...@gm...>]

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

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

[Alexander P. <ale...@gm...>]

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.


Regards,
Alexander
-- 
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru

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

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

[Jorge A. B. <jor...@gm...>]

better choice: rows
not-so-good choice: first (Firebird supported but non standard compliant)

Regards

2011/4/15 Mig/ <mig...@gm...>

> 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
>
>
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve
> application availability and disaster protection. Learn more about boosting
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>