🚀 go-pugleaf

More blob questions :-)

I found this code by Viatcheslav in another post:

TFileStream * Blob = new TFileStream(Form1->Open->FileName, fmOpenRead);
        try
                {
                Form1->query->SQL->Text = "SELECT * FROM map";
                Form1->query->Open();
                Form1->query->Insert();

((TBlobField*)Form1->query->FieldByName("map"))->LoadFromStream(Blob);
                Form1->query->Post();
                Form1->query->Close();
                }
        __finally
                {
                delete Blob;
                }

This works fine, but, it seems to be inserting the image data into a new
row, how can I make it go in a row "WHERE ID = 1" for instance?

Second, when taking the image back out from the database, how would I do
that? Is it just a matter of using SaveToStream instead? An example would be
great.

Third, i'm inserting PNG images with transparent values, and I though I read
somewhere that access databases convert images to bitmaps, is this still
true when it reads LONG BINARY in the field? Shouldn't the image be the same
when taken out as when putting it in?

In advance thanks!