Hi,

>>Worked OK for generating the XML and getting it back into a cursor. Couldn't think of a simple way of getting the 'received' cursor back to it's original structure though. Since I've got control of the client side as well I went with STRCONV(x,13) ---> STRCONV(x,14)
>>

>Did you try to generate XML with inline schema?

= CURSORTOXML(ALIAS(),"lcXml",1,0,0,"1")

You mean when using the binary memo approach ? Yes:

ALTER TABLE myTable ALTER COLUMN myField M NOCPTRANS
=CURSORTOXML("myTable","fred",1,0,0,"1")
** Inline XSD defines myField as Base64, <myField> content is 
** translated to base64 and
=XMLTOCURSOR(fred,"test")
** creates myField as binary memo as expected but then I can see no easy way
** of reverting this field to it's original C(5) type (whilst preserving the field name).

Also the ALTER TABLE hits problems if there are long field names ("Invalid operation for the cursor").

Using the STRCONV() approach myField is, of course, still defined in the XSD as a string but it doesn't matter in this instance since I'm the only consumer. Anyway I assume that if ness. I could just tweak the XSD to define myField as base64 encoded...

Regards,
Viv