In my Delphi application I use a SQL Server 2008 database.
Since I've updated to XE2 I have a problem with one customer which report the error:
"144.54 is not a valid BCD value"
This is also the only customer that works on Windows MultiPoint Server 2011.
It turns out that the regional settings for decimal-separator was set to "." (point) instead of a "," (comma).
In Delphi however the application sets the separator by code:
ThousandSeparator := '.';
DecimalSeparator := ',';
// For ReportBuilder 12 - uses ppUtils
ppFormatSettings.DecimalSeparator := DecimalSeparator;
ppFormatSettings.ThousandSeparator := ThousandSeparator;
Application.UpdateFormatSettings := False;
// For DevExpress
cxFormatController.UseDelphiDateTimeFormats := True;
// change other settings of the cxFormatController...
Does anybody have an idea how to solve this? Is my code correct?