Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG?: blobs and CursorToXML/XMLToCursor
Message
De
01/11/2004 04:23:45
 
 
À
01/11/2004 03:43:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Divers
Thread ID:
00956461
Message ID:
00956468
Vues:
8
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform