JavaScript Editor js editor     Web development 

Main Page

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


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.


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.


The following example shows how the XML schema type simpleType, as defined, is mapped to Currency in Visual FoxPro:

В Copy Code
   <xsd:restriction base="xsd:decimal">
   <xsd:totalDigits value="19"/>
   <xsd:fractionDigits value="4"/>

See Also

JavaScript Editor js editor     Web development