Product Information

Product: DataMapper 2008
Version: 2008
Operating System: All

Document Details

Symptoms:

DataMapper is not converting the destination data correctly when I use the format (###,###.##) for the real (decimal ) data type. It starts placing commas every three digits from the left.

Resolution:

This comes from a misunderstanding of how DataMapper uses formats. DataMapper 2008 follows Microsoft's .NET format convention. For example, a number that is formated to have commas in it as well as two decimal places to the right would be formatted as:

###,###.00

More help can be found at http://msdn2.microsoft.com/en-us/library/0c899ak8.aspx