I need to send an XML document object to VFP stored procedure by way of oCommand.ExecuteNonQuery(). I pass XML object as one of parameters in oCommand.CommandText. I tried the following choices:
1. oXml but this sends just the name of the xml document.
2. oXml.InnerText sends the text of the node but without tag names.
3. oXml.OuterXml gives me error.
Basically I want the Stored Procedure to receive a string of the xml document so that in VFP I can convert it to a cursor.
Any suggestions, please?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham