MapN19_4ToCurrency Property
Specifies whether to map the XML type xsd:decimal to the Visual FoxPro Currency data type when the XML facets totalDigits and fractionDigits are 19 and 4 respectively. You can set the MapN19_4ToCurrency property to preserve precision. Read/write.
MapN_4ToCurrency applies only when executing the LoadXML and Attach methods, which retrieve XML consistent with its setting.
XMLAdapter.MapN19_4ToCurrency [= lValue]
Return Value
lValue
Logical data type. The following table lists the values for lValue.lValue Description False (.F.)
Does not map xsd:decimal to Currency. (Default)
True (.T.)
Map xsd:decimal to Currency. The XML facets totalDigits and fractionDigits must be 19 and 4 respectively.
Remarks
Applies To: XMLAdapter Class
By default, Visual FoxPro maps xsd:decimal to Numeric. However, you can retain currency type precision by mapping xsd:decimal to Currency instead of Numeric. For example, SQL Server currency fields are represented in XML as decimal 19,4 with 19 total digits and 4 digits following the decimal point.
For more information about Visual FoxPro and XSD data type mapping, see Visual FoxPro and XML Schema Data Type Mapping.
Example
The following example shows how the XML schema type simpleType, as defined, is mapped to Currency in Visual FoxPro:
<xsd:simpleType>
<xsd:restriction base="xsd:decimal">
<xsd:totalDigits value="19"/>
<xsd:fractionDigits value="4"/>
</xsd:restriction>
</xsd:simpleType>
See Also
Reference
XMLAdapter Object Properties, Methods, and Events
Currency Data Type
Numeric Data Type
LoadXML Method
Attach Method (Visual FoxPro)