Bug 50383

Summary:	EDITING: Creating a form for a multi table query does not allow updating
Product:	LibreOffice	Reporter:	Tetsuya <dash_3_0_0>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID
Severity:	major	CC:	dash_3_0_0, lionel, zreizinger
Priority:	high
Version:	3.5.3 release
Hardware:	Other
OS:	All
See Also:	https://issues.apache.org/ooo/show_bug.cgi?id=53377
Whiteboard:	BSA
Crash report or crash signature:		Regression By:
Attachments:	sample odb to see what happens.

Description Tetsuya 2012-05-27 00:58:49 UTC

Created attachment 62134 [details]
sample odb to see what happens.

Problem description: 

https://issues.apache.org/ooo/show_bug.cgi?id=53377

It seems that this problem is not solved yet on LibreOffice Base 3.5.3

My English is not so good so please see the link above. The situation is the exact same.


Steps to reproduce: Please check the attached sample file.
There are two tables. (main, eventTable)
Filed main.eventID and eventTable.eventID(primary key) is registerred as a relation

In Query, "query1" is generated from table "main" and "eventTable".
In Form, "main" is generated based on table "main".
              "query1"is generated based on query "query1"

On the form "main", I can update ( LibreOffice works in the correct way)
But on the form "query1", I cannot update ( doesn't work )


1. ....
2. ....
3. ....

Current behavior: I cannot edit the data on the form.

Expected behavior: I can edit the data on the form

Platform (if different from the browser): Ubuntu 12.04 LTS  ( I confirmed that this problem happens at least in Windows Vista 32bit )
              
Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_4) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.46 Safari/536.5

Comment 1 madmuffin 2012-06-02 01:25:03 UTC

was able to reproduce this bug with LibreOffice Base 3.5.3

This bug was fixed in AOO 3.3

Comment 2 Zoltán Reizinger 2012-06-02 09:53:54 UTC

The update in query window (and in forms), works only when all primary keys present in query.
In your database query not contain both PK.

See:
http://wiki.services.openoffice.org/wiki/Base/New_features_in_3_3#Base_now_supports_updates_on_more_than_one_table

Comment 3 Lionel Elie Mamane 2012-06-02 10:27:59 UTC

Concretely, in the attached example, edit "query1" to add the field "eventTable"."eventID". Save it. Then double-click on the query, can edit the data and insert new data. Open form "query1", can again edit data and insert new data.