Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Illegal conversion by XMLTOCURSOR() causes error
Message
From
08/11/2001 15:13:44
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Illegal conversion by XMLTOCURSOR() causes error
Miscellaneous
Thread ID:
00579330
Message ID:
00579330
Views:
83
I use IE data binding from XML data island with data types.
The ONLY way to implement this seems to use dt:dt attribute.

However, FoxPro 7 XMLTOCURSOR() ignores data types. It converts string data to numeric. For wide fields, this causes error.

How to avoid error in the following code ?

How to create FoxPro cursor using xmltocursor() so that invoicenumber is numeric field ?

Remove spaces after < characters when trying to run the following code.
cXML = '< DocHead xmlns:dt="urn:schemas-microsoft-com:datatypes"> < row>< invoicenumber dt:dt="string">123456789012345678901< /invoicenumber>< /row>< /DocHead>'

* Result: 
* XML parse error: field width or number of decimal places is invalid.
* Is this bug or "behaviour by design"
xmltocursor( cXML )
Andrus
Next
Reply
Map
View

Click here to load this message in the networking platform