Apologies the Firebird version is 2.0.3.



Thomas.



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Clarke
Sent: Wednesday, November 21, 2007 9:05 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Bankers Rounding



Hello to everyone,

I have the following challenge:

I am manipulating data extracted from an Informix 10 database using Java,
JayBird and Firebird 2.1. The output file is going to be imported into an
ACCPAC accounting application. The challenge I face is that ACCPAC expects
the numbers to be rounded using Bankers Rounding
(http://www.cis
<http://www.cis.udel.edu/~breech/contest/problems/bankers-rounding.html>
udel.edu/~breech/contest/problems/bankers-rounding.html).
Does anyone know of a UDF or a technique that can provide this type of
rounding in Firebird?

Thanks.

Thomas Clarke.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]