Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to prevent XMLTOCURSOR from throwing away leading ze
Message
 
 
To
12/12/2005 10:06:18
Mike Sue-Ping
Cambridge, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01077117
Message ID:
01077125
Views:
36
This message has been marked as the solution to the initial question of the thread.
TEXT TO lcXml NOSHOW 
<?xml version="1.0" ?> 
<LWRESPONSE>
<M_0>
<MNUM>V509850</MNUM> 
<LUD>091220050239</LUD> 
</M_0>
<M_1>
<MNUM>F2525799</MNUM> 
<LUD>091220050246</LUD> 
</M_1>
</LWRESPONSE>
ENDTEXT

CREATE CURSOR Test ( Mnum C(8), Lud C(12))
XMLTOCURSOR(lcXml, ALIAS(), 8192)
BROWSE LAST NOWAIT
>
>I'm trying to use XMLTOCURSOR on the following string:
>
>
><?xml version="1.0" ?>
><LWRESPONSE>
><M_0>
><MNUM>V509850</MNUM>
><LUD>091220050239</LUD>
></M_0>
><M_1>
><MNUM>F2525799</MNUM>
><LUD>091220050246</LUD>
></M_1>
></LWRESPONSE>
>
>
>After it converts to a cursor, the values in the LUD field have dropped the leading zero. The values in the cursor are "91220050239" and "91220050246". Is there a way to keep all digits using XMLTOCURSOR()?
>
>TIA
>
>Mike
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform