Subject RE: [firebird-support] Numeric(18,4) calculations
Author Maya Opperman
>Please understand that

> (Qty * UnitPrice * 1.14) as ExtValueInclVAT


> LTemp = (:OQty * :OUnitPrice);
> LTemp = LTemp * 1.14;
> OExtPriceInclVAT = LTemp;

>are actually quite different calculations when using scaled

So I could use

declare variable
LTemp double precision

In place of

LTemp numeric(18,2)

(leave everything else exactly as is)
and have the best of both worlds?

Or will the final assignment still give me an overflow error?


[Non-text portions of this message have been removed]