Devart Forums

Hi,

I am trying to use the EnableBCD option available in the SQLConnection parameter. But still the float fields returned by the query are of type TFMTBCDFileld instead of TFloatField.
I hope this was the purpose of the parameter EnableBCD.
If not, can someone please explain me the purpose.

Thank You,
Praveen.

Sorry. realised my mistake. I was using TSQLConnection. I should be using TCRSQLConnection if this option has to work.

Where can I find the help for all the parameters available in the corelab connection component. I have purchased the components but could not find the help in readme.

Please refer to section "Extended driver options" in ReadMe.html.

Our company developed in the past years a couple of applications based on firebird db. Right now (due customers requests) we are considering porting our applications to oracle.

We downloaded demo dbexpress drivers for oracle and everything seems to work fine except for few quirks.

We set to false EnableBCD to get integer fields for datatype Decimal(x) where x=10

We anyway discovered that fields with datatype Deciamal(x,y) are returned as floats and not as BCD.

Is there any parameter or work around.

thank you.

When EnableBCD option is turned on all numeric fields are represented as BCD field types. Otherwise they are represented as integer and float field types.

In case we purchase a coupe of dbx drivers for oracle we get the source as well. Do you think it would be hard to make a patch on our own to return a bcd field in case the db field has a precision greater than zero?

thank you.

Source code of all our products, including dbExpress drivers, is well
formatted and easy to understand. However, the product is not a simple
one, so you have to have good skills in object-oriented programming in
order to modify the source code. And you should acknowledge that we would
not support these changes.