Subject RE: [ib-support] Blob Field
Author Thomas Steinmaurer
Hello Hans-Wolfgang,

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

Well, with the above INSERT statement, you simply insert
the string 'd:\multimedia\pictures\signature.bmp' into
your BLOB field, but not the "true" bitmap from your HDD
at the given location.

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

> 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]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>