I had a go... Is the only history at Yahoo? (Were they want to know all
sorts of personal information (including your credit card number (for
age verification!!)... I just want to have a look at some archived news
items Mr Yahoo, I don't really want to go though all that hassle, and
really, why do you care where I work or what the name of my dog is!...)

Sorry... Frustration slipping out...

I also tried searching on the Atkin news group but nothing turned up
about unbiased or bankers rounding, just a few messages on rounding in
general.

Any more info appreciated :-)

Regards
Colin

-----Original Message-----
From: Hans Hoogstraat [mailto:hans@...]
Sent: Wednesday, 9 April 2003 5:37 p.m.
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] "Bankers Rounding" Function


There was an excellent solution posted a while back. Can you check the
history of this conf ?

----- Original Message -----
From: "C Fraser" <Colin.Fraser@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, April 08, 2003 11:30 PM
Subject: [ib-support] "Bankers Rounding" Function


> Hi,
>
> Is there an easy way to get "Bankers" or unbiased rounding of numbers
> in Interbase/Firebird?? A function or UDF available?
>
> Just to explain... using 0.145 FormatFloat in Delphi gives 1.5, where
> as FormatCurr gives 1.4 (though the documentation wouldn't give you
> any clue about this).
>
> In our apps we have used FormatCurr and Format('%m', [0.145]) but this

> does not equal what the database spits out... We have determined it is

> because IB/Firebird always rounds up (biased rounding) which is fine,
> just wondering if there is a function to do what we are after
> (otherwise, we shall change all our code to use FormatFloat instead,
> not tooooo much of a biggie).
>
> Regards
>
> Colin
>
>
> ######################################################################
> Attention:
> The information in this email and in any attachments is confidential.
> If you are not the intended recipient then please do not distribute,
> copy or use this information. Please notify us immediately by return
> email and then delete the message from your computer. Any views or
> opinions presented are solely those of the author.
> ######################################################################
>
>
> 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/
>
>
>



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/



######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################