Devart Forums

i try and evaluate your product and
i want to migrate from ADO.

I use SQL server 2008

for field with DataType Numeric(28,12)
in ADO recognized TBCDField

but in TUniQuery recognized to float

if i set EnabledFMTBCD property True,
TUniQuery recognized to TFMTBCDField

so get error

Type mismatch for field '' expecting: BCD actual: TFMTBCDField

How to solve this?
i want to keep TBCDField

Any mapping tool/property to maping datatype?

Thanks

Sorry for my English

Set EnableBCD = True and EnableFMTBCD = False.

I'm sorry too long too response

i already do this before.
Set EnableBCD = True and EnableFMTBCD = False

but DataType Numeric(28,12) still TFloatField
i want to keep TBCDField. Because too complex problem to convert to TFloatField.

You can create for Numeric(28,12) SQL Server data type only TFMTBCDField field, because there are some limitations for TBCDField in Delphi:
MaxBcdPrecision = 18;
MaxBcdScale = 4;