Unidac + BCD Fields + Client Datasets = 0 values
Posted: 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.
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.