[Libreoffice-bugs] [Bug 121886] Firebird: Datatype Image(BLOB) is not working properly with Form or Report image controls.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121886

--- Comment #15 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Created attachment 152240
  --> https://bugs.documentfoundation.org/attachment.cgi?id=152240&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190616/f7101db9/attachment.html>