Devart Forums

Hi,

What is the difference between using EnableFMTBCD and EnableNumbers options in TOraSession?

I have a table with a number column that no precision or scaling defined and it contains a number that is upto 21 in length.

If both options are false I get something like 1.4324254897E3 but if either one is true the number is displayed correctly.
If both options are set to true the default is that I get TFMTBCDField
The help/doc file is not quite up-to-date: https://www.devart.com/odac/docs/?devar ... ptions.htm
as there is no mention of BCD fields or BCD options.

So witch one should I use for large oracle numbers TFMTBCDField or TOraNumberField ?
And what is the difference between those two?
And does it affect speed when using those enable[datatypes] options in TOraSession?

-Arni

Anyone ?

On EnableNumbers=True the dataset fields with Precision > 15 will be mapped as TOraNumberField.

On EnableBCD=True the dataset fields with Precision > 9 And Scale <5 will be mapped as TBCDField.

On EnableFMTCD=True the dataset fields with Precision > 15 will be mapped as TFMTBCDField.

Thanks

Feel free to contact us if you have any further questions