EnableBCD

praveenjalem · Post by **praveenjalem** » Mon 08 May 2006 06:34

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.

praveenjalem · Post by **praveenjalem** » Mon 08 May 2006 06:55

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

praveenjalem · Post by **praveenjalem** » Mon 08 May 2006 06:59

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.

Challenger · Post by **Challenger** » Wed 10 May 2006 09:23

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

cristian · Post by **cristian** » Thu 11 May 2006 14:22

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.

Challenger · Post by **Challenger** » Fri 12 May 2006 09:08

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.

cristian.prevedello · Post by **cristian.prevedello** » Tue 16 May 2006 12:54

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.

Challenger · Post by **Challenger** » Thu 18 May 2006 11:51

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.