Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Chr(13) / chr(10) in memo fields
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Divers
Thread ID:
00895846
Message ID:
00895902
Vues:
20
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.
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform