Devart Forums

Congratulations, UniDAC is really impressive!

I'm testing latest Version with SqlServer support.

When i set EnableBCD and EnableFMTBCD options of UniQuery to True i have :

Firebird:
Numeric(5,2),Numeric(10,4), Numeric(18,4) : Mapped to TBCDField.
Numeric(18,6): Mapped to TFMTBCDField.
All tests with firebird OK.

SqlServerExpress 2005:
Numeric(5,2),Numeric(10,4), Numeric(18,4) : Mapped to TBCDField. (OK)
Numeric(18,6): Mapped to TBCDField.
When i save the record to Database, Numeric(18,6) field value is rounded with four decimal places.


It's a problem to me because i need to change from Firebird to SqlServer using same application.

Do you have any idea about this issue?

Joao Cadilhe.

This is a bug and it will be fixed in the nearest time. As a temporay solution we can suggest you to map all numeric fields to the TFMTBCDField. To do this you should set EnableBCD to False and EnableFMTBCD to True.

It's ok. Thank you.