Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Northwind BLOB to BMP File
Message
From
15/09/2004 20:27:19
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Miscellaneous
Thread ID:
00942652
Message ID:
00942688
Views:
18
Mark,
before VFP 9.0 beta you could see the image with a Oleboundcontrol,
now in VFP 9.0 beta you can use an Image object in the form to do the same.
You just have to refresh it when you get it in the CA when you recover it from a RDBMS

something like this to refresh...
SELECT("CA_Pubs_info")
LOCAL x
x = CA_Pubs_info.LOGO
THISFORM.Image1.PictureVal = x
THISFORM.REFRESH
In this case CA_Pubs_info is the CursorAdapter from the Pub_info table in SQL server Pubs database.

PS: in CA: MapBinary = .T. to work !

[ ],s
Peter

>Selecting the data from the MSDE Northwind database, you get a BLOB field with the employee photo. This was a BMP file. STRTOFILE() is not really working to get this back to a BMP file. How can I use the contents of this BLOB field to display the picture in a VFP form? What ActiveX control do I use for the BMP? TIA!
Previous
Reply
Map
View

Click here to load this message in the networking platform