Mmmmm, don't know what/how you're doing this, but on FB1.0 the following:

select 157809.0000*1.00000000/1077 from rdb$database

yields

146.526

here at work.

Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@...

-----Original Message-----
From: news.clix.pt [mailto:agostinho.cpis@...]
Sent: Friday, September 20, 2002 9:41 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] Bug in Calculate Fields. Please Help


Hi people

I have a big problem.
I'm using FB-1.0.0.796-0.64IO.i386.rpm and when I define a calculate field
like
NUMERIC(18,4)*NUMERIC(18,8)/INTEGER i got wrong values

eg. 157809.0000*1.00000000/1077=14652.6462
when the correct value is 146.5264

Thanks in advance

Agostinho Sousa
agostinhocpis@...






To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/