Thanks for the quick reply. If the driver is working as designed, then perhaps the issue is indeed with the client app's language. I will test further. In any case I know I can solve the problem by CASTING the returned variable to the type needed.
Jonathan Finch Principal Consultant Rushmore Information Services, LLC > On December 3, 2014 at 3:02 PM Dimitry Sibiryakov <s...@ibphoenix.com> wrote: > > > 03.12.2014 20:40, jfi...@rushmoreinfo.com wrote: > > 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. > > It should return value of SQL_BIGINT or SQL_NUMERIC types. Perhaps, your > software is > not ready to work with these types and ask for conversion to text > internally?.. > > -- > WBR, SD. > > ------------------------------------------------------------------------------ > 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 ------------------------------------------------------------------------------ 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