Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with CursorToXML() an back XMLToCursor()
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Titre:
Problems with CursorToXML() an back XMLToCursor()
Versions des environnements
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Divers
Thread ID:
01072858
Message ID:
01072858
Vues:
75
I'm converting a cursor to XML

CursorToXML('mytable','myoutput.xml') works fine the thing is when I try to convert it back with XMLtoCursor('myoutput.xml','mycursor') I get the error: "XML Parse error: Field width or decimal places is invalid"

The problem is that a character field in the original table contains only digits but is a 40 character field (example: "435553463785876868678", and when the XMLtoCursor tries to convert it back it assumes that is a numeric and overflows the numeric limits and generates an error.

Is there a way to specify to the cursortoxml function to state that thisfield is character en not numeric?

Thanks in advance
Jorge Flores
From the Amigo Country
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform