General information
Title:
Proble with XMLToCursor()
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:
Look at the field "U.M." and to what happens when i use xmltocursor() to create the cursor "Cursor1":
CODIGO DESCRICAO PRECO U FAM_PAI
117762 BANANAS IMPORTADAS 1.05 1
117768 ANANAZ MADEIRA 1.12 1
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.
As you see the field "U.M." has disappeared from the cursor and became the field "U" with no data.
Thank you,
Joaquim
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only