Page 1 of 1

BCD Overflow

Posted: Wed 22 Jun 2011 17:51
by Rodolpho
Hi,

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

Code: Select all

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.

Posted: Thu 23 Jun 2011 11:15
by AlexP
Hello,

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

Posted: Fri 24 Jun 2011 14:35
by Rodolpho
Hi,

Delphi7
CRSQLConnection

Posted: Mon 27 Jun 2011 14:47
by AlexP
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.

Posted: Mon 27 Jun 2011 16:50
by Rodolpho
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?

Posted: Wed 29 Jun 2011 07:12
by AlexP
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 .