Subject RE: [ib-support] 3 * 1/3 = 0 ???
Author Wilson, Fred
Opps, sorry, forgot to mention that. We're currently using Dialect 1.

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



-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: Friday, August 30, 2002 7:20 AM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] 3 * 1/3 = 0 ???


At 30/08/2002 11:12 AM, you wrote:
>Well, you'll be happy to know, that on FB1.0, using QuickDesk
>
>SELECT (1/3)*3 FROM RDB$DATABASE = 1.000

Using which dialect? I'm using Dialect 3 and get an answer of 0. The
operation (1/3) seems to result as an integer, so the result would be 0,
because of the rounding algorithm.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)



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/