Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement