>Hello Sergey !
>
>During the last weeks you helped me a lot with my MYSQL-beginner problems.
>Thank you again.
>Everything works quite well now.
>I even can store and receive pictures or excel-data to or from blob fields !!!! ;-)
>But there is a strange behavior in foxpro that makes me crasy.
>
>I have a customer form f1 from witch i call a second modal form where i handle the blobs !!
>( his picture, his calculation ....)
>
>When i click on a button "infos" of form f1 i do "do form f2 with customernr"
>
>At init of form f2 i do select * from t_blobs where customernr = parameter into cursor xyz
>
>thisform.oleboundcontrol1.controlsource = xyz.picturefield &&blob
>thisform.oleboundcontrol2.controlsource = xyz.calcfield &&blob
>thisform.txtxxx.value = xyz.xxx ...
>.
>In form f2 can chose another picture or another xls as controlsource for the oleboundcontrols via getpic() or getfile().
>I can store the new content into the blob fields of my t_blobs table in the mysql database.
>Everything works good.
>I even can work with the olebountcontrols in f2 via doubleclick ! (paint or excel is opened and i can do some changes). I can store the changes in my t_blobs table !
>But ......
>When back in form f1 and clicking on the button "infos" again there is an error message
>"The table buffer of the alias "xyz" does still contain undone changes"
>
>I don't think, that this is a problem with MYSQL because when i click ignore and form f2 is opened , everything is ok! All my changes to the oleboundscontrols are ok !!
>It must be a problem with the temporary cursor xyz.
>I can't get rid of this error ???
>I use cursor xyz only at the init event of form f2 !!
>
>*read infos
>lcSql = [SELECT * from t_blobs where tabelle = ?p_tabelle and keyfeld = ?p_keyfeld]
>*if conection ok !!
>if p_connection >= 0
> =SQLEXEC(p_connection,lcSql,(thisform.p_cursor))
>ENDIF
>
>I don't use xyz when storing data back to t_blobs.
>
>The error occurs only when i changed the content of the oleboundcontrolls in form2 via doubleclick not when changing via getfile()
>I tried tableupdate and tablerevert with xyz at unload of form f2, the error disappears when starting f2 again but my changes are not stored in t_blobs then!??
>
>Any idea ???
>Best regards

Hi Albert,

It sounds like somethin related to a buffering. I would suggest that you create a new thread so maybe somebody else can help you.