Questions about EnableBCD and BCD Overflow error

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Posts: 11
Joined: Tue 01 Dec 2009 12:56

Questions about EnableBCD and BCD Overflow error

Post by ez » Thu 11 Feb 2010 09:21


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

  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 :
Oracle 10g

Devart Team
Posts: 19
Joined: Tue 02 Feb 2010 10:40

Post by Falcon » Mon 15 Feb 2010 16:54


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,
Devart Team

Post Reply