Problems with decimals of a FMTBCD-Field reading a View

Problems with decimals of a FMTBCD-Field reading a View

Postby 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

Posts: 17
Joined: Thu 30 Apr 2009 10:01

Postby 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.
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Return to dbExpress driver for Oracle