when EnableBCD=True, but numeric(16,2) will turn ftFloat

[samin]

I connect MSSQL2000, I see inside the help to have such a section:

Data Types
[3] - The appropriate Delphi type is chosen using the following sequence of rules:
EnableBCD is True and field precision, scale is less or equal 14,4 - uses ftBCD;
EnableFMTBCD is True - uses ftFMTBCD;
uses ftFloat.


Why has such definition?
I now am some fields am numeric(16,2)，But set EnableBCD=True,
This field's type actually turned ftFloat, this was not I needs,
I did not want to turn ftFloat, ask how to solve?

Thanks

[samin]

my version is 3.0.0.8

[Dimon]

This limatation occurs because Delphi defines max bounds for TBcd fields like this:
MaxBcdPrecision = 18;
MaxBcdScale = 4;

[samin]

This limatation occurs because Delphi defines max bounds for TBcd fields like this:
MaxBcdPrecision = 18;
MaxBcdScale = 4;

MaxBcdPrecision = 18,
But UniDac is 14?

[Dimon]

But real Precision should be less or equal (MaxBcdPrecision - MaxBcdScale) and Scale <= MaxBcdScale.

[samin]

A field is numeric(18,2), we can evaluate are 123456789012345.12,
In BDE, I create TBCDField for it, it run very well
Showing, most greatly is not 14, but is 15

[Dimon]

Ok, we have fixed this problem. This fix will be included in the next UniDAC build.