Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
String field in XML turning to numeric after XMLTOCURSOR
Message
 
 
To
22/12/2005 14:59:06
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
Miscellaneous
Thread ID:
01080310
Message ID:
01080315
Views:
15
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform