Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XMLTOCURSOR() with invalid characters
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01638686
Message ID:
01638722
Vues:
132
XML does not support binary string data, so if you plan on encoding memo fields that contain sub char(32) characters you need to convert those fields to BLOB fields (CAST(val AS W)) so that they are base64 encoded when converted to XML.
CREATE CURSOR temp (val w)
INSERT INTO temp val VALUES (CHR(10) + CHR(15) )
lcXml = ""
? CURSORTOXML("Temp","lcXml")
which produces:
<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
<VFPData>
	<temp>
		<val>Cg8=</val>
	</temp>
</VFPData>
+++ Rick ---

>Hi,
>
>I am storing an encrypted string into an XML file. But when I try to load this XML into a cursor I get error "An invalid character was found in text content". The code of loading the XML file is:
>
>XMLTOCURSOR( "MyXmlFile.xml", cCursorName, 512+8192)
>
>
>And this encrypted string is stored in XML using CURSORTOXML(). What do I need to do when storing or loading this stgring to make it work?
>
>TIA
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform