Hi again, Tore, and thanks for your reply.
The XML is created with a so-called inline schema, which is a definition consisting of, amongst other things, the data types of the fields, so there should be no confusion there.
>I may very well be wrong, and I must also confess that I have never used binary data with xml. Have you tried to create the cursor2 with the correct field type before issuing xmltocursor()? You know, unless you specify the structure of the cursor, xmltocursor has to make a guess, a guess which is often wrong. One example of this is that you have a field in your xml where tha value is only 0 or 1, xmltocursor will guess that the field type is logical. I ALWAYS create the cursor first, then I use the 8192 flag for xmltocursor.
>
>>>Blob=binary, jpg=binary, xml=NOT binary. You are trying to accomplish something which was never intended to work!
>>
>>Then why is the data encoded in the xml with data type "base64binary"? I believe this should indeed work.
>>
>>
>>>
>>>>Try the following:
>>>>
>>>>
>>>>Create Cursor curTest (image blob)
>>>>Append Blank
>>>>*!* Select a jpg file from your harddrive here:
>>>>Replace image with FileToStr(GetFile())
>>>>?CursorToXML("curTest", "lcTest", 1, 0, 0, "1")
>>>>?XMLToCursor(lcTest, "curTest2")
>>>>
>>>>
>>>>Observe that after the cursor has been translated to xml and back, the image field is no longer a BLOB, but a MEMO field.