Hi Sergey

This is the command:

Xmltocursor("c:\MyFile.xml","tmp_cursor",512 + 2048)

and this is the file:
(look at field "gnreValor" it does not have decimals)

- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- <s:Schema id="RowsetSchema">
- <s:ElementType name="row" content="eltOnly" rs:CommandTimeout="30">
- <s:AttributeType name="gnreID" rs:number="1" rs:writeunknown="true">
  <s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false" /> 
  </s:AttributeType>
- <s:AttributeType name="gnreValor" rs:number="2" rs:writeunknown="true">
  <s:datatype dt:type="number" rs:dbtype="currency" dt:maxLength="8" rs:precision="19" rs:fixedlength="true" rs:maybenull="false" /> 
  </s:AttributeType>
  <s:extends type="rs:rowbase" /> 
  </s:ElementType>
  </s:Schema>
- <rs:data>
  <z:row gnreID="885822" gnreValor="68" /> 
  <z:row gnreID="885919" gnreValor="748" /> 
  <z:row gnreID="885981" gnreValor="633" /> 
  <z:row gnreID="885988" gnreValor="45" /> 
  <z:row gnreID="886044" gnreValor="89" /> 
  <z:row gnreID="886057" gnreValor="3050" /> 
  <z:row gnreID="886090" gnreValor="205" /> 
  <z:row gnreID="886119" gnreValor="73" /> 
  <z:row gnreID="886123" gnreValor="38" /> 
  <z:row gnreID="886128" gnreValor="24" /> 
  <z:row gnreID="886135" gnreValor="185" /> 
  <z:row gnreID="886154" gnreValor="90" /> 
  <z:row gnreID="886176" gnreValor="40" /> 
  <z:row gnreID="887492" gnreValor="27" /> 
  <z:row gnreID="887500" gnreValor="165" /> 
  <z:row gnreID="887590" gnreValor="95" /> 
  </rs:data>
  </xml>

>Hi Frederico,
>
>How the XML file is created? Does it include incline schema? Can you post a small sample XML?
>BTW, the money data type is stored as 8 bytes integer on SQL Server and with corresponded format NUMERIC (19,4).
>
>>Hello *.*
>>
>>We have some fields type MONEY in a recordset, when we save this data from recordset to a XML file and make a local VFP cursor these fields was created as NUMERIC (14,0)
>>
>>this is the command:
>>

>>Xmltocursor("c:\teste\arq.xml","tmpXML",512 + 2048))
>>

>>
>>How can we transform it to NUMERIC (14,2) like the data type MONEY defined into SQL SERVER?
>>
>>Wea are using VFP 7.0 Service pack 1
>>
>>Tanks in advance.