Issue 107845 - Subform link to MainForm is broken
Summary: Subform link to MainForm is broken
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.2 RC1
Hardware: PC All
: P2 Trivial (vote)
Target Milestone: OOo 3.2
Assignee: marc.neumann
QA Contact: issues@dba
Keywords: regression
: 108116 108276 (view as issue list)
Depends on:
Blocks: 99999
  Show dependency tree
Reported: 2009-12-22 21:13 UTC by luzius
Modified: 2010-01-13 23:12 UTC (History)
4 users (show)

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

Sample database with form "Adherents" (343.17 KB, application/vnd.sun.xml.base)
2009-12-22 21:15 UTC, luzius
no flags Details
patch as committed (for the record, for review, for ...) (657 bytes, patch)
2010-01-06 09:51 UTC, Frank Schönheit
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description luzius 2009-12-22 21:13:20 UTC
The simple link by an integer value between the main table "Adherents" and the
subform table "Eleves" is broken.

The link is OK up to OOO320m7 (Build:9641) but is broken in OOO320m8 (Build:9472).
A sample database will be annexed

Merry Christmas and best regards - Luzius
Comment 1 luzius 2009-12-22 21:15:24 UTC
Created attachment 66769 [details]
Sample database with form "Adherents"
Comment 2 drewjensen.inbox 2009-12-23 06:31:50 UTC
Haven't had the chance to try this on XP - checked with Ubunu 9.10 / OO.o 3.1.1
and 300m_7

I could not reproduce your problem. Using the Adherents form in the attached
file I did receive an error on inserting new records in the sub-table, but this
was in both version of OO.o and in both cases the error is a Foreign Key
violation for Professor - there is a problem with how you are displaying that
column, such that it displays '0' for all entries. But you must enter a valid
string value for a new record insert.
Comment 3 luzius 2009-12-23 07:12:57 UTC
2atjensen: It is normal that you could'nt reproduce the error!

I mentioned that this form works well in ALL version 3.0, 3.1.x and developer
releases up to OOO320m7 (Build:9641), but the subform is empty in version 3.2.0
french (installed from OOo_3.2.0rc1_20091217_Win32Intel_install_fr.exe).

So please try it with the RC1 version. Thank you
regards Luzius

Comment 4 vitriol 2009-12-23 07:41:18 UTC
Seems a regression and a showstopper for me... please, consider fixing before
3.2 final.
Comment 5 vitriol 2009-12-23 07:44:12 UTC
Add me to CC
Comment 6 drewjensen.inbox 2009-12-23 15:23:00 UTC
@luzius - Yes, sorry. Retested with Ubuntu 9.10 / OOO320_RC1


Change Platform, added keyword regression, assign to developer
Comment 7 drewjensen.inbox 2009-12-23 15:25:27 UTC
and maybe even set to new...
also chenged sub-component to none.
Comment 8 vitriol 2009-12-23 17:34:21 UTC
I've nominate this issue as a stopper for 3.2 on ML
Comment 9 ud 2009-12-24 20:06:44 UTC
I can confirm it with WinXP and OOO320m8
Comment 10 uwe.luebbers 2009-12-28 11:13:15 UTC
set target
Comment 11 Frank Schönheit 2010-01-04 10:33:20 UTC
correcting priority, and starting investigations.

Indeed this broke between m7 and m8. Interestingly, EIS says that no DBA-CWS has
been integrated into m8 ...
Comment 12 Frank Schönheit 2010-01-04 10:58:43 UTC
argh - regression of my fix for issue 107485. Fix is straight-forward, but need
to wait until our infrastructure ends its New-Year-vacation, and I can create a
CWS ...
Comment 13 Frank Schönheit 2010-01-04 11:15:43 UTC
fixed in CWS dba32k

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
Comment 14 Frank Schönheit 2010-01-05 14:53:39 UTC
fs->msc: please verify in CWS dba32k
Comment 15 marc.neumann 2010-01-06 09:27:24 UTC
verified in CWS dba32k and issue 107485 still works too.

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
Comment 16 Frank Schönheit 2010-01-06 09:51:36 UTC
Created attachment 67019 [details]
patch as committed (for the record, for review, for ...)
Comment 17 ocke.janssen 2010-01-06 11:48:10 UTC
Patch verified.
Comment 18 Frank Schönheit 2010-01-06 20:40:35 UTC
*** Issue 108116 has been marked as a duplicate of this issue. ***
Comment 19 Frank Schönheit 2010-01-13 08:34:21 UTC
*** Issue 108276 has been marked as a duplicate of this issue. ***
Comment 20 luzius 2010-01-13 10:40:08 UTC
I just installed OOo 3.2 RC2: the subform displays the correct data again.
Thanks to all the developers and specially to fs for fixing this error.
Best regards  Luzius
Comment 21 drewjensen.inbox 2010-01-13 23:12:21 UTC