Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this XML ???
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01346090
Message ID:
01346099
Views:
17
>You can use STREXTRACT()

The info that is "blah blah blah" looks like binary information. Can I use XMLTOCURSOR to extract it??

Thanks!

>
>TEXT TO lcXml NOSHOW
><?xml version="1.0" encoding="utf-8" ?> 
>  <base64Binary xmlns="http://tempuri.org/literalTypes">blah blah blah</base64Binary>
>ENDTEXT
>
>? STREXTRACT(lcXml, [<base64Binary xmlns="http://tempuri.org/literalTypes">], [</base64Binary>],1,1) 
>  
>
>>
>>Question
>>
>>Is this XML data (below...)?? I removed the "data" part in the middle and put blah blah blah there for privacy of the data.
>>
>>
>>
>>?xml version="1.0" encoding="utf-8" ?> 
>>  <base64Binary xmlns="http://tempuri.org/literalTypes">blah blah blah</base64Binary
>>
>>
>>
>>If it is, how do I convert it to a Cursor? Use XMLTOCURSOR ??? I tried that, but was not able to get it to work. If so, how do you do it??
>>
>>Thanks!
Tommy Tillman A+ NetWork+ MCP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform