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)
>
©2004 Mike McCann |
