""drp90064"" <dan@...> wrote in message news:a49871+g3bk@......

> 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?

This is only an idea. Sum uses all available space according to the manuals.
It means the sum is executed in a field
numeric(18,2)
and the engine may be confused when converting back to numeric(15,2).

I don't have any proof of my hunch, so the only way is:
- prepare a db with only ONE record per involved table.
- leave only the tables needed and the failing proc.
- ensure the failure happens.
- backup it.
- then I will take a peek. It's painfully slow to debug those things because
they involve a lot of internal steps. So, the simpler the case, the better.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing