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:
01346093
Views:
15
You can use STREXTRACT()
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!
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform