Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG?: blobs and CursorToXML/XMLToCursor
Message
From
01/11/2004 04:23:45
 
 
To
01/11/2004 03:43:39
Eyvind W. Axelsen
Profdoc Norge As
Oslo, Norway
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00956461
Message ID:
00956468
Views:
7
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform