Problems with decimals of a FMTBCD-Field reading a View
Posted: 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
Devartfan
[/img]
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
Devartfan
[/img]