Questions about EnableBCD and BCD Overflow error

Questions about EnableBCD and BCD Overflow error

Postby ez » Thu 11 Feb 2010 09:21

Hi,

I have a few questions about the EnableBCD option.
To avoid BCD overflow errors on DOUBLE PRECISION fields, I have to use the following code :

Code: Select all
const
  coEnableBCD = TSQLConnectionOption(102);

  SQLConnection1.SQLConnection.SetOption(coEnableBCD, 0);


- Is this the only way to avoid the error ? My application is not specific to Oracle, but I have to write specific code to handle this ?
- Why are DOUBLE PRECISION fields not mapped to TFloatField by default ?
- What is the difference with EnableBCD=False on the connection string ? The latter always raises the BCD Error.

Thanks for your answers.

Configuration :
Delphi 7
dbxoda : 4.50.0.20
Oracle 10g
ez
 
Posts: 11
Joined: Tue 01 Dec 2009 12:56

Postby Falcon » Mon 15 Feb 2010 16:54

Hello.

1. Yes, it's the only way.
2. Could you please specify if you mean double precision or binary_double Oracle type.
3. You have to use the TCRSQLConnection component instead of TSQLConnection.

Best regards,
Anton
Devart Team
www.devart.com
Falcon
Devart Team
 
Posts: 19
Joined: Tue 02 Feb 2010 10:40


Return to dbExpress driver for Oracle