Hi Albert,

Take a look at How to work with Image field type on SQL Server (binary data)? FAQ #7995. It should give you some ideas on how to store and retrieve data. BTW, what's the format of the pictures you're working with?

>Hello everbody !
>Sorry but here i am again. I asked this last week, but it ended in a discussion wether it would be a good idea to store pictures in a blob-field?!
>
>To shorten is:
>My application communicates with an SPS (Siemens S7) of an measurement system
>(roboter). I have to collect measurement results for each measured part, then
>the results are passed to an CAD 3D system, witch does some visualisation and
>produces a picture of each measured part. My customer wants the data and the picture of each part to be stored in a MY-SQL-Database on an Linux Webserver(Apache + PHP) where he has his own apps to publish the results to a very special community (a lot of security, public data and special data for his customers ....).
>!!! I have to put everything in an MY-SQL-Table !!!!
>
>Now i'm experimenting(fighting) with foxpro(6.0),mysql and blob-fields.
>
>I have a form with an oleboundcontrol
>
>With getpic() i select the picture and show it
>
>local l_picture
>create cursor justtostupid(mypicture G)
>append blank
>l_picture = getpict()
>append general mypicture from (l_picture)
>thisform.oleboutcontrol.controlsource = 'justtostupid.mypicture'
>thisform.refresh
>
>This works but i'm sure that using a cursor is a stupid solution !!
>How to do this more directly (objekt_variable)???
>
>Then i have to store the picture in a mysql-table (fieldname mypicture type blob) and delete it from the filesystem.
>Guess what ?? again to stupid !!
>l_mypicture = ????????
>l_ok= SQLEXEC(p_connection,'UPDATE xyz SET mypicture = ?l_mypicture where ...')
>
>Of course i must be able show the stored data and the picture in my form later.
>
>select * from xyz into cursor mycursor
>thisform.oleboundcontrol.controlsource = ???????
>
>Can this be done with Foxpro and if how ??????
>
>Any help welcomed
>Best regards
>Albert