Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field Money and XML
Message
 
 
À
20/08/2003 12:17:46
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Divers
Thread ID:
00821849
Message ID:
00822968
Vues:
24
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform