Unidac + BCD Fields + Client Datasets = 0 values

kamiller42 · Post by **kamiller42** » Thu 27 Jan 2011 23:00

I have a table in a database in SQL Server 2005; the database is in SQL 2000 compatibility mode. The table has two numeric fields, one numeric(9,0) and the other numeric(4,0).

When I query the table using a Unidac component and display in a grid, the numeric values appear. If I attach a datasetprovider and TClientDataSet to the provider and open the client dataset, the numeric values display as 0.

EnableBCD and EnabledFmtBCD are enabled on the Unidac dataset.

Is there a translation error between Unidac and ClientDataset? Am I missing an option?

Unidac 3.50.0.14
Delphi 2007 w/service packs.

Additional Note:
If I set EnableBCD and EnableFmtBCD to False, the Unidacs instantiate FloatFields, but from what I have read in numerous places, BCD is preferred, which is why I am trying to get it to work.

AndreyZ · Post by **AndreyZ** » Mon 31 Jan 2011 14:41

Hello,

We have reproduced the problem and the investigation of the problem is in progress. As soon as we solve the problem we will let you khow.