Invalid setting of BCD fields using SQL Server Compact 3.5
Posted: 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.
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.
