Using xmltocursor, xmladapter, or what?


>You are absolutely correct. My VFP Stored procedure parses the XML string sent by the ASP.NET. What I was saying that so far, I was simply parsing the XML string and setting the values of the XML elements to the columns of VFP tables. The problem was that elements of XML file (string) had the "&" + "amp" + ";" (of course, if your of ASP.NET entered ampersand sign). So now I will have to "clean" up the string from the XML file (as I parse it) of this "undesirable" characters.
>
>>Your stored procedure should parse the file. Can you post your stored procedure? The data should not be stored in xml format if you are accessing from standard VFP controls and data access methods. Your stored procedure should parse the file correctly. Or am I missing something?
>>
>>
>>
>>>>What method are you using here:
>>>>
>>>>>and the XML is then sent to VFP database.
>>>
>>>I call VFP Stored procedure using ExecuteScalar() and passing a string (XML).