In my tests of SQL statements using ODBC driver version 2.0.3.154 with the Firebird 3.0 Beta 1, COUNT(*) is apparently returning a character variable. This is causing some errors in my apps that have always expected COUNT to yield an integer, which is what version 2.0.2.153 of the driver returns, at least with Firebird 2.5 data bases. Perhaps a driver change was made for consistency with other aggregate functions like SUM(), which did return a character under 2.02? To get the integer my apps expect, looks like I'd need to change numerous SQL commands to something like CAST(COUNT(*) AS INTEGER) AS TABLECOUNT. Anyone else experienced this issue?
Jonathan Finch Principal Consultant Rushmore Information Services, LLC ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk _______________________________________________ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
