Questions about EnableBCD and BCD Overflow error

[ez]

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

[Falcon]

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