Issue 107845

Summary: Subform link to MainForm is broken
Product: Base Reporter: luzius <luzius>
Component: codeAssignee: marc.neumann
Status: CLOSED FIXED QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P2 CC: issues, mdxonefour, pet.ebe, vitriol_vitriol
Version: OOo 3.2 RC1Keywords: regression
Target Milestone: OOo 3.2   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 99999    
Attachments:
Description Flags
Sample database with form "Adherents"
none
patch as committed (for the record, for review, for ...) none

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.
Thanks.
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

Confirmed

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 releases@openoffice.org
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:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba32k
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:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba32k
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
closing