🚀 go-pugleaf

Hello Paolo

I'm working on exactly the same.
I have an Access File and want to store pictures into it.
I think we are right to use OLEObject in the Access Table, because if you
use
a DBGrid and access the Access-Table with ADO (and don't set specific
columns to be shown
in the DBGrid - so the DBGrid shows all columns by default), the colum
holding OLEObject
will display "BLOB" (Binary Large OBject - which should be the right one).

To fill that field with BCB5, I took a DBImage-Component from the "Data
Controls" page.

I have this settings for my component DBImage1:

DataSource: DataSource1
DataField: Picture  (<- This is the Access Column OLEObject)

DataSource1 has as DataSet: ADOQuery1

And ADOQuery1 has a ConnectionString where I access through
"Microsoft Jet 4.0 OLE DB Provider" the *.mdb-File


Now what I don't get is:
They write to add a picture into DBImage, you can work with
"Copy'n'paste"...

The only way I found out to add a picture to that DBImage is like this:
Open MSPaint, load a Bitmap picture. Press CTRL-A (to select the whole
picture). Press CTRL-C (to copy the selection) - then click on that
DBImage and press CTRL-V to paste the picture into the DBImage component...

That will save the picture into the Access Database and also work like this

But: Isn't there any other more easy way to fill DBImage with a picture?

I tryed this:
OpenPictureDialog1->execute();
DBImage1->Picture->LoadFromFile(OpenPictureDialog1->FileName);

The result is: The picture is really displayed in my DBImage1-Component now,
but if you click on another Row in the DBGrid and then click back on the
row where you "inserted" the picture with "LoadFromFile" - it's not beeing
displayed anymore :-/

Anybody with a useful hint here?


Best regards,
Alen

-- 
WEB: http://www.come.to/nostromo



"Paolo Borlandi" <pborlandi@virgilio.it> wrote in message
news:3f799037@newsgroups.borland.com...
> I need to store files (any kind) into a db record and retrive it when
asked.
> The db is a Ms Access db.
>
> the field tyte is OLEObject (right?? wrong??)
>
> Have someone some idea or example??
>
> THANK YOU VERY MUCH
>
> Paolo from Italy
>
>
>
>
>
>