Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field Money and XML
Message
 
 
To
20/08/2003 12:17:46
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00821849
Message ID:
00822968
Views:
23
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform