Page 1 of 1

BCD data type is not supported

Posted: Mon 12 Feb 2018 09:09
by simon.thompson
I am completely new to the product so I may have made a simple mistake but I am having this issue with my first attempt to use EntityDAC.
I am running through the getting started routine but using SQL Server and an existing table of my own.
I have an EntityConnection with provider name SDAC and dialect name SQL Server. The connection tests OK.
I have a decimal field in my table and it seems to be this that EntityDAC seems to be objecting to.
Does EntityDAC support decimal fields? If so, what do I need to do?
Are there any other restrictions to EntityDAC.

Re: BCD data type is not supported

Posted: Wed 14 Feb 2018 08:54
by MaximG
Currently, EntityDAC does not support working with the BCD data type. We will add support for this type in one of the next builds of our product.
As a workaround, you can use another type when working with DECIMAL fields. For this, change the default value for the corresponding Type Mapping Rule:
- in EntityDeveloper, select the menu item "Tools"\"Options"
- go to the tab "Servers' Options"\"SQL Server"
- find the rule with Server Type = decimal and click the "Edit" button