Devart Forums

Hello,

We want to map any decimal field in mssql to TFMTBCDField, regardless of number of significant digits. Is there such option in the dbx driver for mssql?

Thanks in advance,
Marcos

Do you use very old driver version (earlier when 1.80)?
By default, all decimal (numeric) fields map to TFMTBCDField. You can disable this behavior by setting EnableBCD to False.

No, we're using v2.50. The field is declared as follows

myfield decimal(6, 2) NULL

This field is always created as TBCDField (or floatfield if enable bcd=false)

This is dbExpress limitation. You should use decimal type with scale larger than 4 or precision larger than 14 to get TFMTBCDField