| Colin Bowern 2006-09-29, 1:31 am |
| Has anyone been able to use the Numeric data type with mapped storage? If I
use
<Column Name="ExchangeRate" DataType="numeric" IsNullable="true" />
I get:
Microsoft.CommerceServer.Runtime.Orders.SqlSchemaValidationException: Column
PurchaseOrders.ExchangeRate referenced in Orders storage mapping file has a
different data type than the corresponding entry in the SQL schema..
If I use the data type with the scale and percision specification as per the
schema editor in SQL Management Studio:
<Column Name="ExchangeRate" DataType="numeric(18,8)" IsNullable="true" />
I get:
Microsoft.CommerceServer.Runtime.Orders.MappingException: Error initializing
Schema mapping. Details: Error G0032 - Column PurchaseOrders.ExchangeRate
type numeric(18,8) is not an allowed relational type.
According to the documentation numeric is a valid type for use in mapping.
I just can't figure out how to get it working and I haven't found any other
examples to indicate the correct way to do this.
Cheers,
COlin
|