Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to copy a blob field into an array of bytes
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01504022
Message ID:
01504712
Views:
76
Thanks James, Naomi, and Gary,

The call to CURSORSETPROP("MapBinary", .T., 0) seems to have done the trick. Under the debugger, I now see that VARTYPE(BlobData) = "Q". And, if I loop over the size of the blob, I can use SUBSTR(BlobData. nInc, 1) to transfer all of the bytes into my array.

So, that seems to have answered that question. I'm not completely sure until I can check this with the client that actually processes the byte array. I'll let you know.

Thanks again,
Jim


>>Grasping at straws here: Can you execute DbSetprop after view creation?
>>DBSETPROP('MyView.Field',"FIELD","DataType","W") && BLOB type
>>
>>I'm not where I can test this so it may not work...
>>
>>Gary
>>
>Check Re: Store pictures on SQL server Thread #1422743 Message #1422754 for SQLExec.
Previous
Reply
Map
View

Click here to load this message in the networking platform