BCD Overflow

BCD Overflow

Postby 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:
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.
Rodolpho
 
Posts: 9
Joined: Wed 15 Jun 2011 13:25

Postby AlexP » Thu 23 Jun 2011 11:15

Hello,

Please specify your Delphi version and the component you are using to execute the specified query.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Postby Rodolpho » Fri 24 Jun 2011 14:35

Hi,

Delphi7
CRSQLConnection
Rodolpho
 
Posts: 9
Joined: Wed 15 Jun 2011 13:25

Postby 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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Postby 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?
Rodolpho
 
Posts: 9
Joined: Wed 15 Jun 2011 13:25

Postby 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 .
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle