Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
Problem writing blob |
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! |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |