[Libreoffice-bugs] [Bug 68153] EDITING: Query input in foreignkey-field impossible, when two tables in the query.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=68153

--- Comment #23 from Howard Johnson <BridgeportContractor at gmail.com> ---
(In reply to robert from comment #22)
> And this is the bug I reported:
> 
> You couldn't change the foreign-key-field, but you could change the content
> of the table, which is linked to the first table by this foreign-key.
> 
> I would prefer:
> You could change the foreign-key-field, but you could not change the content
> of the table, which is linked to the first table by this foreign-key. 
> This would protect the user to unconscious change the content of many rows
> of the first table by changing the content of one field of the second table
> linked to the first by the foreign-key.

Robert, I don't think you see what I'm trying to convey.  Let me try to explain
it again.

First, there is no longer any reason that any field in a query should not be
editable.  Consider this simple set of tables:

    +-----------+
    | Table1 ID |
    +-----------+        +-----------+
    | Table2 FK | -----> | Table2 ID |
    +-----------+        +-----------+
    | Name      |        | Title     |
    +-----------+        +-----------+
    | ...                | ...

    SELECT   Table1 ID, Table 2 FK, Name,   Table2 ID, Title 
    FROM Table1 Right Join Table2 ...

    +-----------+-----------+------+-----------+-------+
    | Table1 ID | Table2 FK | Name | Table2 ID | Title |
    +-----------+-----------+------+-----------+-------+
    |         0 |         0 | Mike |         0 | Clerk |
    +-----------+-----------+------+-----------+-------+

In order:
1) If you edit Table1 ID and move to up or down   
then Table 1 is updated.
   If you instead move right nothing is done.

2) If you edit Table2 FK from 0 to 1, and then move the focus to another cell,
   any prior changes to Table2 ID are pushed to the database, and then
   Name, Table2 ID and Title get updated from the new Table2 ID. 

3) If you edit Name nothing is done until

  If you edit

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170604/d825dd8d/attachment.html>