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

[Walter R. O. V. <sis...@gm...>]

With Visual FoxPro, a column BIGINT is returned as type character, not as
type integer.

But it can be easily converted to integer, with the VAL() function.

Greetings.

Walter.


On Wed, Dec 3, 2014 at 4:02 PM, Dimitry Sibiryakov <sd...@ib...> wrote:

> 03.12.2014 20:40, jf...@ru... 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>