Problems with decimals of a FMTBCD-Field reading a View

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Posts: 17
Joined: Thu 30 Apr 2009 10:01

Problems with decimals of a FMTBCD-Field reading a View

Post by devartfan » Thu 28 May 2009 12:20

Hey Guys,

I have a Problem reading decimals of a FMTBCD-Field when the specific Query uses a View.

Querys using a Table have the right number with decimals.
Querys using a View do something like rounding with the original value.
e.g. the value in the View of 2.69922 is represented in the FMTBCD-Field as 2 without decimals. The value 2.9002 is represented as 3 likewise without the decimals.

Using the useBCD option as FALSE works. But this means to reload every Field of every Query in the whole Projekt. Why does this not work with a FMTBCD field as well?

I use Delphi 2009 with the latest update(3+4) just installed today. The Database is a Oracle 10G. I use the devart dbExpress-Oracle-Driver in Version 440_15.

Kind Regards


Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Fri 29 May 2009 06:36

We could not reproduce the problem. Please send to dbxoda*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

Post Reply