Subject Re: [ib-support] Conversion Error From String (Error 3355443)
Author Jason Chapman (JAC2)
I'm amazed it worked at all considering dialect 1 is for backward
compatability to 5.x, therefore 15,2 is not supported.


> Here's a weird one...
>
> I am running FireBird RC2 on Windows 2000. Client application is
> written in latest IBO4 using latest gds32.dll. Database is running
> Dialect 1.
>
> I have a stored proc which ran just fun until the upgrade from Beta 2
> to RC2. This did not help. The problem was that I would receive
> a "Conversion Error Form String" error message from the server (ISC
> Error Number 3355443) whenever the SP attempted to reference
> variables that were declared as NUMERIC(15,2). The only solution I
> could find was to cast all of the variable references to NUMERIC
> (15,2). Listed below is the "fixed" stored proc. The original one
> was exactly the same minus the CAST(xxx as NUMERIC(15,2)) stuff.
> Does anyone have a clue why this re-casting of variables that are
> already as NUMERIC is necessary?