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

Reply via email to