SQL Server Numeric(28,12) --> Float?

ronininor · Post by **ronininor** » Fri 18 Dec 2009 16:45

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

Plash · Post by **Plash** » Mon 21 Dec 2009 08:51

Set EnableBCD = True and EnableFMTBCD = False.

ronininor · Post by **ronininor** » Tue 05 Jan 2010 08:19

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.

Dimon · Post by **Dimon** » Thu 14 Jan 2010 09:33

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;