Discussion:
[Firebird-odbc-devel] Firebird Latest Odbc "SELECT TOP"
Mig/
2011-04-15 07:11:06 UTC
Permalink
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
Alexander Potapchenko
2011-04-15 07:23:53 UTC
Permalink
Post by Mig/
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
Kjell Rilbe
2011-04-15 07:47:28 UTC
Permalink
Post by Alexander Potapchenko
Post by Mig/
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: ***@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
Jorge Andres Brugger
2011-04-15 15:42:09 UTC
Permalink
better choice: rows
not-so-good choice: first (Firebird supported but non standard compliant)

Regards
Post by Mig/
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Loading...