Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Illegal conversion by XMLTOCURSOR() causes error
Message
From
11/11/2001 08:02:50
 
 
To
08/11/2001 15:13:44
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00579330
Message ID:
00580237
Views:
22
Hi Andrus,

you'll need to supply a schema to xmltocursor in order to force data types and length.

Hank

>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 )
>
Previous
Reply
Map
View

Click here to load this message in the networking platform