Yes, and that's apparently came into play as a result of Firebird 3's change to return COUNT() as a BIGINT rather than integer. So the ODBC driver is declared innocent. Thanks to all for having helped figure out what's happening.
Jonathan Finch Principal Consultant Rushmore Information Services, LLC > On December 3, 2014 at 3:42 PM "Walter R. Ojeda Valiente" > <sistemas2000profesio...@gmail.com> wrote: > > > 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 ------------------------------------------------------------------------------ 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
