General information
Category:
Forms & Form designer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only