Subject RE: [firebird-support] FIB Plus Error
Author Clay Shannon
-----Original Message-----
[] On Behalf Of Ray Jenkins
Sent: Thursday, November 17, 2005 11:01 AM
Subject: Re: [firebird-support] FIB Plus Error

On 11/17/05, Dilish <dilish_tv@...> wrote:
> While Executing my application am getting the following error.
> (Working fine in Win 2003 Servers..!!!)

Does this mean you have two different databases that your trying this
query on, and its working on one but not the other?

> arithmetic exception, numeric overflow, or string truncation.

<<If the above assumption is correct, I would first check that the Table
definitions are the same, this error for me has almost always been my
app trying to send down more string data than I had column width for,
so I would have to go back into my app and guard against strings with
too many characters being sent in a query.>>

Also, if you have used a new TpFIBDatabase component and forgot to change
the SQLDialect property to 3 from 1, this can cause worlds of headaches
(easily remedied, though).

Clay Shannon,
Dimension 4 Software