Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Download picture from SQL server
Message
From
15/05/2001 23:57:49
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00507581
Message ID:
00507683
Views:
25
>Hi,
>
>I have executed remote to download a picture field from SQL Server. The picture came as a GENERAL field into a foxpro cursor.
>i tried to assign the field to an image control on a form:
>
>thisform.image1.picture = mycursor.gfield
>
>but got an error message.
>
>Any take on that?
>
>Thanks, Jonathan

The image1.picture is expecting a string...the name of a file that contains a picture.
I assume your general field contains the actual picture itself. If you have a BMP file embedded in the field, you can use the 'embossedole' class in wizards\wizembss.vcx...drop it on your form and set the properties...and the picture may appear.
If you have a JPG, I believe you have to have an OLE server installed on your machine (such as paintbrush) to get the image to display on a form. You use an OLE control to show the picture.

I can't help you more than that...I store the file name of the picture I want to display in the table, and use the image control.
Steve Gibson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform