[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 #18 from trowelandmattock at yahoo.co.uk ---
There appears to be no fix for this yet, making design/modification of
databases with data difficult for CLOB types, and especially difficult for
migration to firebird with existing database structures.

Here is my work-around for changing a field to CLOB in existing table with
data:

1: create the new intended CLOB field as VarChar
2: copy the table and data to a spreadsheet
3:copy the spreadsheet
4: paste back into base as new table, and use the dialog to change the VarChar
to CLOB as needed - no other method appears to work :/

NB//
The first attempt may not get all the data copied, AND might rearrange some
columns (!!!)

Fix this by creating new firebird DB (for safety) - then copy original table
there, making sure to use initial dialog to set CLOB - proceed through the many
dialog boxes... (errors and all!) - now delete all the spurious data just
leaving the definitions - note if any column order has changed - now copy the
original data to a spreadsheet, and modify to match any changed columns in new
version - now copy spreadsheet and append to the new table - check it again as
the first row seems to get buggy, but all the other data should be there
...sigh.



Love You Libre! (firebird don't us down now please:)

-- 
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/20200815/ed31129c/attachment.htm>