Mike,
On the toXML side, why not convert chars outside the range legal range of
chars to something like &###; (like HMTL does) and on the XMLto side,
convert your &###; patterns back to binary chars.
The ### would be the ASCII numeric code, i.e. in your case, chr(26) would
be converted to &026;
Just an idea ...
Malcolm
----- Original message -----
From: "Mike McCann" <mcsoft at cox DOT net>
To: profoxtech@leafe.com
Date: Wed, 31 Mar 2004 16:52:08 -0600
Subject: Re: XMLToCursor ??
lctest = "this is a string"+CHR(26)+;
"this is more string"+CHR(13)+CHR(10)
*** add NOCPTRANS to create a binary Memo field
CREATE CURSOR c1 (f1 M NOCPTRANS)
APPEND BLANK
REPLACE f1 WITH lcTest
CURSORTOXML('c1','lcXML',3,2+4+8,0,"1")
XMLTOCURSOR(lcXML,"c2",4)
Does the trick. My success was limited because in the wider case, I
have found no way for SQL Server to store and retrieve my Binary Memo
field.
Thanks,
Mike
----- Original Message -----
Subject: XMLToCursor ??
> Why does CURSORTOXML create an XML that XMLTOCURSOR can't extract
> (or am I missing a setting)??
>
> lctest = "this is a string"+CHR(26)+"this is more
> string"+CHR(13)+CHR(10)
> CREATE CURSOR c1 (f1 M)
> APPEND BLANK
> REPLACE f1 WITH lcTest
> CURSORTOXML('c1','lcXML',3,2+4+8,0,"1")
> XMLTOCURSOR(lcXML,"c2",4)
>
[excessive quoting removed by server]
©2004 profox |
