Re: Delphi and BLOBs in informix...

Posted in 1996

Alan Goodman — 31 Oct 1996 15:38:24 -0500 — source: Informix-list mailing list archive (1991-1998)

From james r. coplin: >does anyone know how to embed BLOBs into an informix table. i tried >using a field of type binary but the app hangs whenever i try to put >anything into the field or take anything out. i'm trying to store small >graphic thumbnail jpgs of our products along with their quote info. any >help would help keep my hair on my head instead of in my fists. later. You can use the SaveToStream method. define a blobstream: var BlobStream : TBlobStream; {instantiate it} BlobStream := TBlobStream.Create(qryBlob.FieldByName('THE_BLOB_FIELD') as TBlobField, bmWrite); TheBitmap.SaveToStream(BlobStream); {save the bitmap to the blobfield} BlobStream.Free; {clean up} ------------------------------------------------------------------------------ Alan Goodman | Data Systems Support Senior Systems Analyst | A Client Technologies Company internet : alan@dssmktg.com | 1228 Shelly Ct. Voice 714-771-0454 Fax 714-771-3028 | Orange, CA 92868 USA ------------------------------------------------------------------------------