As discussed in several previous threads, it is a bad idea in general to store a picture in a database. You should instead store the picture in a file and put the path\name in the database.



>Hello everbody !
>i'm experimenting(fighting) with foxpro(6.0),mysql and blob-fields.
>
>i have a form with an oleboundcontrol
>
>with getpic() i select an 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 want to store the picture in a mysql-table (fieldname mypicture type blob)
>guess what ?? again to stupid !!
>l_mypicture = ????????
>l_ok= SQLEXEC(p_connection,'UPDATE xyz SET mypicture = ?l_mypicture where ...')
>
>and of course show the stored picture in my form later
>select * from xyz into cursor mycursor
>thisform.oleboundcontrol.controlsource = ???????
>
>any help welcomed
>best regards
>Albert