Subject Re: [firebird-support] Strange API string truncation error
Author Richard Wesley
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"
>> 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