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).
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"