On May 11, 2007, at 10:31, Richard Wesley wrote:

>
> I have just run across a problem reading back data from a connection
> using the IB API. The query is
>
> SELECT ((EXTRACT(YEAR FROM "Calcs"."datetime0") || '')) AS
> "none:B11703:nk"
> FROM "Calcs"
> GROUP BY 1
>
> the error is
>
> File: db\firebirdprotocol.cpp, Line: 1534
> Status: 335544321
> arithmetic exception, numeric overflow, or string truncation

Sorry, I forgot the code versions:

Server: FB 2.0
Client: FB 2.0 embedded library
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html