Subject RE: [ib-support] Blob Field
Author Thomas Steinmaurer
Hi Jack,

> I have created a FB database, one table of which has blobs. The blob fields
> are set with subtype 0 (binary). I populated the table with several
> different .bmp's using the insert query, which succeeds.
>
> Now I would like to view the contents of the blob with a Delphi database
> app. I have used two different data access component sets (tIB_ and tIBO).
> Both fail with the error, "Bitmap image is not valid". Since the error is
> repeated in both cases, I am inclined to suspect that I have not set up the
> table properly.

By using a BLOB column with sub_type 0 you have set up your table correctly.

I guess you are using TDBImage for viewing the bitmap, right? If so, I think
there went something wrong, when you have inserted the BMPs. How does your
above mentioned insert query look like? Any code snippets?

Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com