BCD Overflow

Rodolpho · Post by **Rodolpho** » Wed 22 Jun 2011 17:51

Hi,

I want to use TFmtBCDFields with Oracle NUMBER datatype but when i simply try to do this:

select 10/3 from dual

I have a message error "BCD Overflow".

I cannot use "EnableBCD=False" params.

How i can fix it? My driver version is: 4.40.0.14.

AlexP · Post by **AlexP** » Thu 23 Jun 2011 11:15

Hello,

Please specify your Delphi version and the component you are using to execute the specified query.

Rodolpho · Post by **Rodolpho** » Fri 24 Jun 2011 14:35

Hi,

Delphi7
CRSQLConnection

AlexP · Post by **AlexP** » Mon 27 Jun 2011 14:47

Hello,

This problem is connected with the specifics of working with TsimpleDataSet and we cannot change this behaviour. To solve this problem, you can use TSQLDataSet or TSQLQuery instead of TsimpleDataSet.

Rodolpho · Post by **Rodolpho** » Mon 27 Jun 2011 16:50

Hi,

I try to use:

- TSQLDataSet
- TSQLQuery

And not fix it....
I saw here (http://www.devart.com/forums/viewtopic.php?t=20407) that bug was fixed in 4.80. I really need upgrade my version to solve this bug?

AlexP · Post by **AlexP** » Wed 29 Jun 2011 07:12

Hello,

I cannot reproduce this problem – when using TSQLQuery and TSQLDataSet everything works correctly even with your version (4.40.14).

Try to download the latest version of dbExpress driver for Oracle (4.90.25).
If this does not solve the problem, please send a small sample demonstrating the problem to alexp*devart*com .