Database Rounding Error

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Matthew Butler Fri, 24 Sep 1999 00:00

#1535

Author: Matthew Butler
Date: Fri, 24 Sep 1999 00:00

11 lines
846 bytes

Hi,

I've been using currency fields in an estimating prog and using calculated
fields to work out total costs, but they don't seem to round correctly
(about 1 or 2 pence out ). This is providing abit of a problem and I was
wondering if anyone
had an info on the subject.

Any help is much appreciated

Mat (mat@magenta-mis.com)

Re: Database Rounding Error

#1538

Author: Harold Howe [TeamB]
Date: Fri, 24 Sep 1999 00:00

11 lines
1061 bytes

> I've been using currency fields in an estimating prog and using calculated
> fields to work out total costs, but they don't seem to round correctly
> (about 1 or 2 pence out ). This is providing abit of a problem and I was
> wondering if anyone had an info on the subject.

I recommend that you switch from TCurrencyField to TBCDField. To do so,
set the EnableBCD property of your alias to true. Then, recreate all of
your persistent fields, if you have any.

Harold Howe [TeamB]
http://www.bcbdev.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads