Re: Re[2]: [Firebird-devel] Computation problem in 1.5RC3

[Calin I. P. <pc...@rd...>]

----- Original Message ----- 
From: "Gabriel Juncu" 
> So, can anybody tell me how can I get correct arithmetic in Firebird
> on 18 digits without overflow errors?
> 
Hmmm, yes.

Use numeric(18,0) as intermediate values then you only get a overflow 
if the result realy overflows.

Ex:
CREATE PROCEDURE W_NUMTST (Param1 numeric(18,4), param2 numeric(18,4))
RETURNS (
 Res NUMERIC(18,4))
AS
  declare variable n1 numeric(18,0);
  declare variable n2 numeric(18,0);
  declare variable n numeric(18,0);
begin
  n1 = param1*10000;
  n2 = param2*10000;
  n = n1*n2;
  res = n/10000;
  suspend;
end


Ciao,



Best regards,
Application Developer
Calin Iancu, Pirtea
S.C. SoftScape S.R.L.
pc...@rd...