Questions about EnableBCD and BCD Overflow error

Questions about EnableBCD and BCD Overflow error

Postby 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
Posts: 11
Joined: Tue 01 Dec 2009 12:56

Postby 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
Devart Team
Posts: 19
Joined: Tue 02 Feb 2010 10:40

Return to dbExpress driver for Oracle