Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Formatting issue with XML column
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01365487
Message ID:
01365489
Views:
22
This message has been marked as the solution to the initial question of the thread.
Hi Simon,

See if http://www.berezniker.com/content/pages/visual-foxpro/loading-xml-web-browser-control-variable could work for you.

>I am trying to display a XML column coming from a SQL 2005 table in the nicely formatted layout that I can see if I open it within SQL Management Studio.
>
>I do not have an XSD file.
>
>I have used SPT to get a table with a single column which is a memo datatype. When I open this, the XML is there, but as text with no line breaks etc, and very difficult to read.
>
>I have tried using XMLTOCURSOR and get parsing errors, but nothing is reported as wrong when I view in SQL.
>
>Are there any ways of viewing this XML in a properly formatted layout, say in an edit box (this is for viewing only by the way).
>
>Thanks
>Simon
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform