Subject | Re: [firebird-support] How do I Store/Retrieve graphics to/from BLOBs using IBQuery? |
---|---|
Author | Woody (TMW) |
Post date | 2003-08-15T00:17:02Z |
> Hi All,As Helen says, this isn't a Delphi list. But, if you mention Firebird on the
>
> I'm trying to store and retrieve graphics (Bitmaps and JPEGs)
> to/from a BLOB field in one of my Firebird (1.5) Tables. I've looked
> all over the place for the answer and the only ones I can find
> involve TFields and TIBTables but I need to use a TIBQuery.
>
> I'm thinking along the lines of creating a Param and streaming the
> graphic to/from it. Unfortunately I'm at a loss as to how to do it.
>
> Thanks for any help you can give me.
Delphi list, you will mainly get redirected here, as well. If my answer
doesn't help enough, post this question in
borland.public.delphi.interbaseexpress without mentioning Firebird.
You need to utilize the streaming methods of the graphics components or a
graphic file. Use a TIBBlobStream created with the CreateBlobStream method
of the TIBQuery. Then, you can use the CopyFrom stream method to copy from
one to the other.
Woody (TMW)
Freeware Page: http://users.eonet.net/woodytmw
Success always occurs in private, and failure in full view.