https://bugs.documentfoundation.org/show_bug.cgi?id=101230
Bug ID: 101230
Summary: EDITING: Embedded Firebird - Creating relationship in
GUI doesn't show existing relations
Product: LibreOffice
Version: 5.3.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rob...@familiegrosskopf.de
Created attachment 126494
--> https://bugs.documentfoundation.org/attachment.cgi?id=126494&action=edit
Testdocument with 2 Firebird-tables without any relation. Try to create as
described.
Since a patch for bug 71009 the dialog for creating of a relationship with
Firebird appears. You could add tables. You could also connect fields (PK of
one table to FK of the other). But the result won't be shown.
Try the following with the attached database:
1. Open table "Name".
2. Write down in first row '1','Bob','1'
> Entry could be saved, because there isn't any foreignkey.
3. Delete the crated row.
4. Enter Tools > Relationships
5. Add the tables to the relationship-dialog.
6. Draw with left mouse from "Name"."TownID" to "Town"."ID"
> There isn't any line shown, which connects the fields of the two tables.
7. Save the relationships.
8. Open table "Name".
9. Write down in first row '1','Bob','1'
> Entry could not be saved, because there is a foreignkey and the row in the
> table "Town" doesn't exist.
10. Enter Tools > Relationships
> There is a connection shown between the header of the two tables, not between
> the fields, which should be connected. Editing of the connection is
> impossible, because the dialog seems to know nothing of the connection it has
> been created in 6. Its the same when creating a connection directly by SQL.
> Wouldn't be shown, too.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
