Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
General field
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00427023
Message ID:
00427116
Views:
18
>>I need to pull photos from SQL Server 7 where they are stored in general fields, but VFP 6 or 7 doesn't seem to be able to do anything with them. Anyone know what's going on?
>
> Use OLE Bound Control tied to general field to show pictures.
> In addition, MS recommends also to use 'DoVerb' for general fields, but I know little about that and I never seed complete list of commands for different types of General field content.
> If you don't have much of photos on server (just started new project), I recommend you do not use general fields at all to store binary data. I tried the same to store different kinds of document files (pictures, DOC files, ZIP archives), but seems VFP have no function reverse to 'APPEND GENERAL' command, so I decided to use another approach. It is quite complex, but more reliable and allows to save any binary data of any size on SQL server. If you're interested, I may post this solution here.

Yes, I would be interested. I have no choice but to try to get the data out of SQL Server. I need to be able to at least pull the pictures up via modify general then copy the file to the clipboard. From there I should be able to do a strtofile(). If I can get to the data without the errormessages I'm currently getting, I'll be in good shape.

Post your code, I'll use what I can.

Thanks,
John Harvey
Shelbynet.com

"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform