Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Formatting issue with XML column
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01365487
Message ID:
01365489
Vues:
21
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform