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

[bugzilla-daemon]

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

--- Comment #21 from trowelandmatt...@yahoo.co.uk ---
(... and to confirm, this is still the behavior in LO 7.1.3.2 )

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #20 from trowelandmatt...@yahoo.co.uk ---
EDIT: actual error for me is

"

Any[Type[com.sun.star.sdbc.XClob],
com.sun.star.bridges.jni_uno.JNI_proxy@6c7ed3b5
[oid=4bde9030;mscx[0];2496293a89a44266bb876e15a5bad382,
type=com.sun.star.sdbc.XClob]]

"

Love you Libre!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #19 from trowelandmatt...@yahoo.co.uk ---
Description:
LibreOffice 6.4 and prior versions - Base Report Writer displays the following
for each CLOB record:


Any[Type[com.sun.star.sdbc.XClob],
com.sun.star.bridges.jni_uno.JNI_proxy@7ee0f142
[oid=7f627403f070;gcc3:affine[0];fe0d3ee695f4212879a7aa3fb6ec575,
type=com.sun.star.sdbc.XClob]]


Steps to Reproduce:
1. Create a Query/View/Table with a CLOB field
2. Create associated Report (inc the clob field).

Results:  
The folowing is printed in place of the actual CLOB data in each record:

Any[Type[com.sun.star.sdbc.XClob],
com.sun.star.bridges.jni_uno.JNI_proxy@7ee0f142
[oid=7f627403f070;gcc3:affine[0];fe0d3ee695f4212879a7aa3fb6ec575,
type=com.sun.star.sdbc.XClob]]

Expected Results:
LO Base Report Writer prints contents of CLOB field.


Reproducible: Always


User Profile Reset: No


Version: 6.4.7.2 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: en-GB (en_GB); UI-Language: en-GB
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #18 from trowelandmatt...@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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #17 from Robert Großkopf  ---
https://bugs.documentfoundation.org/show_bug.cgi?id=115893#c16 has nothing to
do with this bug. This bug is about CLOB in Report-Builder. Report a new bug
for your special problem.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #16 from trowelandmatt...@yahoo.co.uk ---
https://ask.libreoffice.org/en/question/193710/how-create-clob-field-in-design-view-in-base-firebird/

This is sadly still a problem on Win7 and Win10 /Base 6.4.3 / Firebird & GUI
methods on empty tables: - CLOB can only be created via the wizard...

CLOB will not save in design-table view ...

And any changes to any other field in a table with CLOB / BLOB will
result in all CLOB / BLOB being turned to BLOB...!!!(wtf)

It is not possible to alter a CLOB to another type or vice-versa, and
same is true for tables copied in from HSQL2.x project:

"firebird_sdbc error: *unsuccessful metadata update " ...sadness:(

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Drew Jensen  changed:

   What|Removed |Added

 CC||lu...@web.de

--- Comment #15 from Drew Jensen  ---
*** Bug 122400 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #14 from Drew Jensen  ---
(In reply to Drew Jensen from comment #13)
> *** Bug 122167 has been marked as a duplicate of this bug. ***

FYI - after testing that issue, using the test files with a HSQL embedded ODB
and a MEMO field, which works fine with the 6.2Beta build, changed that other
issue to new as it is specific to FB and Mailmerge.  Leaving this link in the
see also property however.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Drew Jensen  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||2167

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Drew Jensen  changed:

   What|Removed |Added

 CC||aalexande...@gmail.com

--- Comment #13 from Drew Jensen  ---
*** Bug 122167 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 Blocks||108745


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108745
[Bug 108745] [META] Report Builder bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||1886

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #12 from Drew Jensen  ---
Created attachment 142449
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142449=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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Drew Jensen  changed:

   What|Removed |Added

Summary|LO Base Report Builder Does |LO Base Report Builder Does
   |Not Display CLOB (memo  |Not Display CLOB (memo
   |field) Data of External |field) Data of External
   |HSQLDB  |HSQLDB and Firebird
   ||(embedded / file)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Drew Jensen  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #11 from Drew Jensen  ---
Created attachment 142447
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142447=edit
same error firebird engine

using a field defined as BLOB SUB_TYPE 1 (CLOB) in odb files with both embedded
and file firebird type and getting the exact error in report builder as
reported. 

Here is the embedded firebird test file with one table and report.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 CC||drewjensen.in...@gmail.com,
   ||xiscofa...@libreoffice.org

--- Comment #10 from Xisco Faulí  ---
@Drew, Do you reproduce this ?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #9 from Alex Thurgood  ---
Can't test this as using an external hsqldb.jar screws up my LO installation on
Mac.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

Summary|LO Base Report Builder Does |LO Base Report Builder Does
   |Not Display CLOB (memo  |Not Display CLOB (memo
   |field) Data |field) Data of External
   ||HSQLDB

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs