Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with XMLToCursor()
Message
 
 
To
17/09/2002 03:36:56
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00701121
Message ID:
00701201
Views:
27
You can use < pre > tag (no spaces) to keep formating and tags.

>I need help in using the xmltocursor() function.
>When i import XML data, if one of the fields from the XML file has a dot (.) in it's name, that field will not be correctly imported.
>
>Example:
>
>The following is an example of two lines from the XML file:
>
><item Codigo="117762" Descricao="BANANAS IMPORTADAS" Preco="1.05" U.M.="KG"
 Fam_Pai="001" Familia="001001" IVA="5" Data_Inicio="2002/09/10" Data_Validade="" 
Moeda="EUR" Al_NAl_Tab_Taras="6" />
>
><item Codigo="117768" Descricao="ANANAZ MADEIRA" Preco="1.12" U.M.="KG" 
Fam_Pai="001" Familia="001001" IVA="5" Data_Inicio="2002/09/10" Data_Validade="" 
Moeda="EUR" Al_NAl_Tab_Taras="6" />
>
>Look at the field "U.M." and to what happens when i use xmltocursor() to create the cursor "Cursor1":
>CURSOR1:
>CODIGO  DESCRICAO                PRECO  U       FAM_PAI   ...
>117762  BANANAS IMPORTADAS        1.05          001
>117768  ANANAZ MADEIRA            1.12          001
>
>The code i used was:
>X = XMLTOCURSOR(m.caminho, "Cursor1", 1536)
>
>Where "m.caminho" it's a string with the name and location of the XML file.
>
>Thank you,
>
>Joaquim
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform