https://bugs.documentfoundation.org/show_bug.cgi?id=100167
--- Comment #14 from [email protected] ---
Thanks Robert, I have seen your attachment and I understand how your subform
works. I'm afraid I didn't read the warning properly about not being able to
enter data without a PK, I assumed it was like Access's warning about not being
able to identify records uniquely - my mistake, and my apologies.
What I don't understand is why the query (or a subform table control based on)
SELECT "issue_cat"."issue", "issue_cat"."cat", "cat"."catdescr" FROM
"issue_cat", "cat" WHERE "issue_cat"."cat" = "cat"."cat"
doesn't allow edits or additions (issue_cat.issue and issue_cat.cat are a
composite primary key.)
If this is the way that HSQLDB is supposed to work, then it is not a bug, and
not an LO bug in any case - but it seems to be at odds with every other
relational database I've used, and I don't understand why this shouldn't be
possible - it seems to me to be broken. If anyone can explain why this is the
correct approach I'd be grateful.
On another note, is there any way to do without quotation marks within SQL
statements? That's a real nuisance.
Thanks Robert, particularly, for your time and assistance.
Just out of interest, is your Base 5.1 handbook available in English?
Thanks
Gareth
--
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
