Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Fri, Apr 1 2011 10:51 AM	Permanent Link
Mirco Malagoli	Hi, in a table I saving a blob field using LoadFromStream method. Q_setImage->ParamByName( "pdata")->LoadFromStream( ms, ftBlob ); Q_setImage->ParamByName( "pidx")->AsInteger= n; Q_setImage->ExecSQL(); this is SQL: "UPDATE nomi SET immagine = :Pdata WHERE idx = :Pidx" After inserting the data, other component that refer to this field seem to having the field empty also after a refresh. If I close and restart the application the blob field is filled and the component (image viewer) load the data in right way. There is a flush command or other similar to work whit blob data? Any other suggestion? DBISAM 4.29 C++2009 Thanks!
Mon, Apr 4 2011 5:55 AM	Permanent Link
Mirco Malagoli	sorry, no problem !! my mistake I'm not refresh the query after the insertion Mirco Malagoli wrote: Hi, in a table I saving a blob field using LoadFromStream method. Q_setImage->ParamByName( "pdata")->LoadFromStream( ms, ftBlob ); Q_setImage->ParamByName( "pidx")->AsInteger= n; Q_setImage->ExecSQL(); this is SQL: "UPDATE nomi SET immagine = :Pdata WHERE idx = :Pidx" After inserting the data, other component that refer to this field seem to having the field empty also after a refresh. If I close and restart the application the blob field is filled and the component (image viewer) load the data in right way. There is a flush command or other similar to work whit blob data? Any other suggestion? DBISAM 4.29 C++2009 Thanks!