Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Viewing images stored by Visual FoxPro
Message
From
29/04/2003 23:12:29
 
 
To
29/04/2003 11:55:12
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00781312
Message ID:
00783007
Views:
12
Hi, Ed.

>Thank you for your efforts. It would be a very easy fix, if I could store the images on the filesystem rather than the database and it is the recommended thing to do, however do to the complexity of our student information system and the ways that it is deployed in school districts I am left with finding a way to pull the images from the database. I know that VFP inserts OLE header information with the raw binary data, however I have been unable to find out the length of this header information; thinking that I might be able to strip off the header info to get only the raw image data.

If the problem is that you need to store the images in the database, I'd recommend that you avoid general fields altoghether and store the image files as is in a binary memo instead (it's quite easy using StrToFile() and FileToStr()). That way you can temporarily extract the original image file without the OLE information. I succesfully retrieve BMP images from a general field, but I could make it because they were all the same type of file.

Other than that, I'll recommend you to go with the filesystem solution, copying the files with a short name corresponding to an identity field. This has proven to be the best approach for me.

As for moving the question, as I explained to Nadya, we don't do it after a message gets replies because it would be confusing. Anyway, you can freely post the same question more than once in different forums, although Ithink you did it in the right one.

Hope this helps,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform