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 <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
