Issue 111959 - Subform with tablegrid does not work anymore
Summary: Subform with tablegrid does not work anymore
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO320m18
Hardware: PC All
: P2 Trivial (vote)
Target Milestone: OOo 3.3
Assignee: marc.neumann
QA Contact: issues@dba
Keywords: regression
Depends on:
Reported: 2010-05-31 14:05 UTC by ud
Modified: 2017-05-20 10:22 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

attached screenshots (163.71 KB, application/pdf)
2010-05-31 14:06 UTC, ud
no flags Details
Example database (15.05 KB, application/vnd.sun.xml.base)
2010-05-31 14:07 UTC, ud
no flags Details
Example database (15.45 KB, application/vnd.sun.xml.base)
2010-05-31 19:25 UTC, ud
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ud 2010-05-31 14:05:20 UTC
I create a form, that works until oooBase 3.2.0.

In ooo 3.2.1rc2 this form does not work anymore. It shows for every entry the
same information. To see what i mean, open the attached pdf file.

I create a simple Bugdoc that shows the error.
Comment 1 ud 2010-05-31 14:06:40 UTC
Created attachment 69729 [details]
attached screenshots
Comment 2 ud 2010-05-31 14:07:24 UTC
Created attachment 69730 [details]
Example database
Comment 3 hmssg 2010-05-31 19:06:54 UTC
Hi, I guess you wanted to attach a database (odb) but caught the wrong file
(odt) :-)
Comment 4 ud 2010-05-31 19:25:36 UTC
Created attachment 69741 [details]
Example database
Comment 5 drewjensen.inbox 2010-06-01 03:34:19 UTC
Confirmed w/ Ubuntu 10.04, OOO320m_18 

Verified that the form functions properly with 3.2

Comment 6 ud 2010-06-29 23:02:52 UTC
I could solve the problem for me.

It was not a problem with the subform grid but with the underlaying table.

That table was a N:N-table with an autoincrement ID as Primary key in the
internal hsqldb. And this table creates "duplicates" from the dataset in OOo 3.2.1.

You can see the duplicates it in the "sample.odb" in table "tblkey_wetter"

So it works for me.
Comment 7 ocke.janssen 2010-07-08 14:33:27 UTC
Fixed in cws dba33g.

Now I see two different entries in the sub grid
Comment 8 ocke.janssen 2010-07-14 11:55:07 UTC
Please verify. Thanks.
Comment 9 marc.neumann 2010-07-20 08:22:36 UTC
verified in CWS dba33g

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System: