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...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 ------------------------------------------------------------------------------ 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 Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
