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.
--sb--