Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to translate SQL Picture (binary array) to DBF Pictu
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00458797
Message ID:
00461312
Views:
22
>>>Vlad
>>>Thanks for the post. It makes a lot of sense. Does the VB -ChrB() function translate to VFP?
>>>> B = B & ChrB(Asc(Mid(Str,I,1)))
>>Terry,
>>
>>ChrB() is identical to the VB Chr() function, which, in turn, is indentical to VFP's CHR(). All return a single byte. ChrW(), returns a wide character.
>Great - What would I use to translate an ADO Recordset 'Picture' attrib field to a binary acceptable to VFP General Field (if it can be done)? The ADO RecordSet field TYPE is: ADLONGVARBINARY (or 205)<g>
>
>PS: I don't even know where to start - maybe there isn't away - but my insomnia demands it <bg>
>Thanks

Terry,

To be frank, I don't know for sure. What type of picture, Bitmap, JPeg or something else? What I do know is that there has to be a file on the local disk. So it would appear that the first part of the answer would be getting the picture field on the disk (STRTOFILE() or low level file I/O). Once on the local disk, you'd simply use APPEND GENERAL...

*** Disclaimers ***

1. I've done zip, nada, nothing with ADO (for various and sundry reasons).

2. I didn't read or don't remember the earlier parts of this thread, so if this was mentioned already, my apologies for the redundency.

3. This above is purely a WAG. IOW, not even scientific.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform