Keith,
Thank you for your suggestion. You are right, it does give the entire document. But I found that something is wrong with the way I created the oXml. So I have to play with the way I create the xml before I can send it.
Again, thank you for your help.
>Dmitry,
>
>Try oXML.DocumentElement.OuterXML. I'm pretty sure that this will give the entire document, but I'm not certain and I don't have access to VS.NET atm.
>
>HTH
>
>>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