https://bugs.documentfoundation.org/show_bug.cgi?id=100167
[email protected] changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #7 from [email protected] ---
(In reply to donotspam from comment #6)
> Created attachment 125517 [details]
> db with behaviour described in my comment at 2016-06-06 18:53:14 UTC
1. You have forgotten to set primary keys for the table "issue_cat". Open the
table for editing, mark both fields while pressing CTRL and set them both as
primary key.
2. You have to test your SQL-code. Copy the code of your subform to a query,
created in SQL-mode. This query couldn't be edited.
SELECT "issue_cat"."issue", "issue_cat"."cat", "cat"."catdescr" FROM
"issue_cat", "cat" WHERE "issue_cat"."cat" = "cat"."cat"
Now add "cat"."cat" to the query. This query could be edited, because the
primary keys of both tables will be content of the query.
3. You don't need this SQL-Code for the subform. You would need the table
"issue_cat" instead. From this table is only needed the field "cat". You have
to change this field to a listfield. This field will show "catdescr" instead of
"cat". So you could see the description and save the primary key.
I will add the changed database as attachment. I will also set this bug to
unconfirmed.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
