Hi All,

I'm getting an error

"Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation."

in a stored procedure. I've been able to duplicate it in the
following.

create procedure spTest
AS
declare variable dPercent Numeric(16,7);
declare variable dConvert Numeric(16,7);
declare variable dPrice Numeric(16,7);
declare variable dBegPrice Numeric(16,7);
Begin
dPrice = 4;
dPercent = .42;
dConvert = 30;
dBegPrice = ((dPrice * dPercent) / dConvert);

suspend;
End

Why is this a problem? When I define my Numerics as (12,3) instead
of (16,7) the problem goes away but I need a greater precision.

I'm not sure whether this is an FB error or is coming from
IBExpert. I caused an access violation in IBExpert that made me use
task manager to end the process.

Thanks,
Steve