>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
See this message
Re: Storing An Image In A SQL Table Thread #
1234808 Message #
1234871
If it's not broken, fix it until it is.
My Blog