On May 11, 2007, at 10:48, Ivan Prenosil 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
>
> Have you tried ISQL ?

Yes, I have (it was at the very bottom of my post) and it works.

I'm puzzled that the buffer sizes returned by the prepare call are
not adequate. The would seem to be and I still get the same error
when I modify them in the debugger to be something ridiculous like 240.
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html