Bug 82884

Summary: Other: Embedded version does not show proper SQL statement output.
Product: LibreOffice Reporter: dreamquartz
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: critical CC: robert
Priority: high Keywords: possibleRegression
Version: 4.3.0.4 release   
Hardware: Other   
OS: Linux (All)   
URL: https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=71684&p=322744#p322744
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=82720
Whiteboard: BSA
Crash report or crash signature: Regression By:
Attachments: Sample database with forms

Description dreamquartz 2014-08-21 02:17:09 UTC
Created attachment 104997 [details]
Sample database with forms

Problem description: When trying to add/modify an entry into a n..m relationship table, and add/modify information based on the selected-related FKs (Foreign Keys) 4.2.6 does show the expected results, while 4.3.0 does not.

Steps to reproduce:
1. Right part of 2nd form; select Company, Select or add address from pull down list, add/modify note.          
Operating System: Ubuntu
Version: 4.3.0.4 release
Last worked in: 4.2.6.2 release
Comment 1 Robert Großkopf 2014-08-21 19:36:42 UTC
Could this be a duplicate of Bug82720 and Bug82905 ? Seems the connection is broken for every subsubform.
Comment 2 Robert Großkopf 2014-08-24 18:46:51 UTC
It's a duplicate of Bug82151, which has been fixed for LO 4.3.2.

*** This bug has been marked as a duplicate of bug 82151 ***
Comment 3 Dan Lewis 2014-08-27 00:48:38 UTC
What I used: LibreOffice 4.3.04 on Kubuntu 14.04 (x86 Deb).

I can modify the note on the right side of the bottom form. When I cycle through the rows of the company addresses, the modification of the Note field appears as it should.

I could not add a note because of an error message about a field being NULL that has the property NOT NULL. This needs to be fixed for this form to work properly.

I would like more information listing the specific steps when using the form ending with 16-08-2014@12:16PM. Which part of the form should have data added to it? Please also name the table that contains the data for each part of the form. What part does the Bare Address and Full Address play in this form?
Comment 4 Dan Lewis 2014-08-27 01:06:54 UTC
(In reply to comment #3)
> What I used: LibreOffice 4.3.04 on Kubuntu 14.04 (x86 Deb).
> 
> I can modify the note on the right side of the bottom form. When I cycle
> through the rows of the company addresses, the modification of the Note
> field appears as it should.

When using Version: 4.4.0.0.alpha0+
Build ID: b6da6a887a0417be02e123a6d19837123e58b94f
TinderBox: Linux-rpm_deb-x86@45-TDF, Branch:master, Time: 2014-08-09_07:47:21; I could also add a value to the Note field.
Comment 5 Robinson Tryon (qubit) 2015-12-15 10:58:03 UTC
Migrating Whiteboard tags to Keywords: (possibleRegression)
[NinjaEdit]