Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting XML into SQL Server Table
Message
From
21/12/2005 08:55:27
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Inserting XML into SQL Server Table
Environment versions
Visual FoxPro:
VFP 7 SP1
Miscellaneous
Thread ID:
01079834
Message ID:
01079834
Views:
42
Hello,
What is the easiest way in VFP7 to take an existing XML document and inserting the values into a table. Right now I am using XMLTOCURSOR, and spinning through the table and inserting the values into a stored procedure, but that isn't going to work if a field isn't included in the XML document. Any suggestions?

TIA,
MAC
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform