Devart Forums

Posted: **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

Posted: **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

Devart Forums

Questions about EnableBCD and BCD Overflow error

Questions about EnableBCD and BCD Overflow error