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

Hier ist das snippet:

insert into ResGraphs ( setupNo, ph1Graph ) values ( 1,
'd:\multimedia\pictures\signature.bmp' );

mfg,

jwc (Hans-Wolfgang)
-----Original Message-----
From: Thomas Steinmaurer [mailto:ts@...]
Sent: Sunday, January 05, 2003 9:18 AM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Blob Field


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





Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]