[Libreoffice-bugs] [Bug 115893] LO Base Report Builder Does Not Display CLOB (memo field) Data of External HSQLDB and Firebird (embedded / file)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #12 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Created attachment 142449
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142449&action=edit
example firebird odb with workaround

There is a workaround if you accept up to 32K of text as a suitable solution,
for today at least, and that is to use a view with the cast function.

This new test file includes a Query and View, both identical SQL:
SELECT "ID", "First_Name", "Last_Name", cast( left( "contacts"."Notes", 1024)
as  CHAR(1024) ) as "Notes" FROM "Business Contacts" "contacts"

Likely a separate issue is found by executing the Query look at Notes content,
then look at the form and report which use that query, empty content for Notes,
while the form and report using the view gets the expected results.

-- 
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/20180531/9cd5694c/attachment.html>