I really wouldn't recommend editing XML directly precisely for this reason. Turning data 'back into valid characters' in badly formed XML is not as easy as it sounds because the characters in question are the ones that make the elements and attributes in a document.

The better way is to edit the data as data then convert the data from an object (or a record in a table) to XML and get it properly encoded. There are many more issues here than just those characters - extended characters, UTF-8 encoding, line feeds, tabs etc. etc. It's just not a good idea. It'll be quicker to just dump the data into a proper fields and building a quick and dirty input form than it is to make sure you end up with valid XML in all cases that you're not accounting for.

+++ Rick ---

>Antonio,
>
>The XML is based on a content of a memo field (editbox) on one of the forms.
>What I am thinking to do is, before converting the memo into the string and into the XML, search for any of these "bad" characters and convert them to "good" characters. For example, convert

<

to LT,

>

to GT and

&

to Ampersand.
>I don't know how often users actually use these characters. I came upon them when testing and using my sample DB where I use all kind of weird characters.
>Thanks
>
>>Dmitry,
>>
>>Since you're allowing the user to edit or prepare the XML document, there is not much you can do besides error trapping. Using current parsers like MSXML you cannot turn a not well-formed XML document into a well-formed XML document. You would have to write a parser for the effect.
>>
>>Does the user has to prepare the data for your system in XML?
>>
>>>Hi,
>>>
>>>I am converting a string into a cursor. The string has values entered by the user (so, I have no control). Here is the simple example:
>>>

>>>CREATE CURSOR CUR_TEMP (NAME C(20), OV M, NV M)
>>>XMLTOCURSOR( cAuditDescr, 'CUR_TEMP', 8192 )
>>>

>>>
>>>What happens is the string cAuditDescr could have characters such as a Less-Than (

<

, Ampersand

&

, Greater-Than (

>

). Any of these characters cause a run-time error.
>>>
>>>How do you suggest I change the code above to allow the values to be in the cursor ("CUR_TEMP") without a run-time error?
>>>
>>>TIA