Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
String field in XML turning to numeric after XMLTOCURSOR
Message
 
 
À
22/12/2005 14:59:06
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
Divers
Thread ID:
01080310
Message ID:
01080315
Vues:
13
Why do you need TYPE() function to determine a field type? You can use DISPLAY STRUCTURE for that. Also, a field cannot have type 'U' so you obviously using TYPE() function incorrectly.

>I have an XML document that has a schema. The schema indicates a field is string (the field contains all numbers, but is still supposed to be string). When I perform XMLTOCURSOR(), the field becomes numeric when I perform the TYPE() function on it. Just as a test I changed the value in the XML document to mixed characters and number, and the TYPE() command returned U. How do I preserve the type when I perform XMLTOCURSOR()? I thought having the schema would do that.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform