[Firebird-odbc-devel] ODBC Driver 2.0.3 COUNT Return Variable Type

[<jf...@ru...>]

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