Hi Francisco,
I'm sorry for bad my English...
You can generete XML from VFP directly with TEXT/ENDTEXT or FPUTS()/FWRITE() or STRTOFILE() and You encode MEMO to base64 s STRCONV() function.
XML is ONLY text file...
...from help TEXT...ENDTEXT coomand
PROCEDURE myProcedure
DO CASE
CASE nValue = 1
TEXT TO myVar NOSHOW TEXT PRETEXT 7
<?xml version="1.0" encoding="utf-8"?>
<DataSet xmlns="http://tempuri.org">
<<ALLTRIM(STRCONV(leRetVal.item(0).xml,9))>>
</DataSet>
ENDTEXT
OTHERWISE
ENDCASE
ENDPROC
MartinJ
>Thank you Martin,
>
>I understand what you said about the bug in xmldom.
>My memos are not binary.
>What exactly do you mean with «you can generate XML programmaticaly» ?
>
>
>
>>Hi Francisco,
>>
>>It's bug in XMLDOM on reading XML.
>>XML DOM convert CHR(13) to CHR(10) and CHR(13)+CHR(10) to CHR(10).
>>If memo is binnary, you can convert it to BASE64.
>>If you have not binnary memos, you can generate XML programmaticaly.
>>
>>MartinJ
>>
>>>I'm having this problem:
>>>
>>>I have a cursor with a Memofield
>>>In this cursor the lines are separated only by the character 13.
>>>
>>>Then I use
>>>
>>>XmlAdpater.addtableschema
>>>
>>>and
>>>
>>>xmladapter.toxml
>>>
>>>To serialize the cursor. The XML comes Ok.
>>>
>>>Later I use
>>>
>>>xmladapter.loadxml
>>>xmladapter.tables(1).tocursor
>>>
>>>to get the cursor back.
>>>
>>>In this moment the Memo field, has its lines separated by the character 10
>>>instead of the character 13 that is in the original cursor.
>>>
>>>How can I solve this ?
>>>
>>>Thank you.