<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Firebird: Datatype Image(BLOB) is not working properly with Form or Report image controls."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121886#c15">Comment # 15</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Firebird: Datatype Image(BLOB) is not working properly with Form or Report image controls."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121886">bug 121886</a>
from <span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=152240" name="attach_152240" title="Example with 3 blob data types">attachment 152240</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=152240&action=edit" title="Example with 3 blob data types">[details]</a></span>
Example with 3 blob data types
Right, so my text got a little confusing.
In the example attached a table with 3 data columns, blob, image(blob), clob.
Looking just at blob and image(blob) data types.
Open Form Blobs.
This has two image controls, one attached to the blob data column, the other to
the image(blob) data type. Both controls allow entering data (double click and
pick an image) but only the control attached to blob data type properly reads
the data.
Open Form qryCastImage2Blob
This has two image controls, one attached to the blob data column, the other to
the uses a cast function to return the image(blob) data type as a blob(blob)
datatype. Both controls display the image data in the table but only the
control but the data is read only.
There is no way, that I found, to display an image from a firebird blob data
type column (blob[blob] or image[blob]).
Clob - off topic but.. can edit data using the Table View but can not be edited
on a form or displayed in a reportbuilder report, displayed by dragging from
the datasource window in Writer or Calc. The data can be displayed, similarly
to image data by using a cast function cast( <clob> as varchar(32000)) for
instance.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>