Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying Pictures in Image Control
Message
From
26/07/2007 12:20:14
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
01243634
Message ID:
01243812
Views:
21
Thanks for the info...now I have a followup problem. This worked great using a blob field in FoxPro. But it needs some tweeking to work with SQL Server.

I've created an image field on the form and I'm using SQL views to the SQL Server Table, in the refresh event I have the following code:

THISFORM.pageframe1.contact.imgContact_Picture.PictureVal = ;
contact.contact_picture && Where contact.contact_picture is field in the view.

I get an error that this is not allowed with General Fields. Now I didn't create a General Field, but an Image field in SQL Server. And I used the following syntax to create the view:

CREATE SQL VIEW someview REMOTE ;
CONNECTION someconnection SHARED ;
AS SELECT * from sometable

So it seems as if VFP interprets the Image Field as a general field when it creates the view. BTW, I first tried using just a "text" (Memo) field and it worked fine, except it blew up on some pictures because of the contents of the picture (it probably had inbedded CHR(0) or something, so that's why I decided I needed to change to an image-type field.

Ideas anyone?

Thanks. Bob
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform