Invalid setting of BCD fields using SQL Server Compact 3.5

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
markwt
Posts: 8
Joined: Wed 24 Jun 2009 15:45

Invalid setting of BCD fields using SQL Server Compact 3.5

Post by markwt » Wed 24 Jun 2009 16:06

SDAC 4.70.0.46 Delphi 7.0
SQL Server Compact 3.5 database

I am just trialing your software everything fine until trying to write values to NUMERIC(9,4) using Data controls or calling various TField properties of either TMSTable or TMSQuery. Executing on TMSSQL is OK.

If I enter a value of 564.2999 or 564.299 the value stored in the database is 564.3

564.89 is OK so there is some strange rounding going on, NUMERIC(9,4) should be OK as this maps in precision to Currency type.

Have set MSCompactConnection1.NumericType to ntBCD and Dataset.EnableBCD := True

This is JUST a SQL Server Compact issue as OK on SQL Server 2008

Any help greatly appreciated only 2 more days left on trial. :( :(

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 26 Jun 2009 09:26

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next SDAC build.

markwt
Posts: 8
Joined: Wed 24 Jun 2009 15:45

Post by markwt » Fri 26 Jun 2009 09:44

Glad to be of service :)

Post Reply