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
Albert