https://bugs.freedesktop.org/show_bug.cgi?id=49708
Mike A. Fargo <mika...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Hardware|All |x86-64 (AMD64)
OS|All |FreeBSD
Version|3.5.2 release |4.0.2.2 release
--- Comment #8 from Mike A. Fargo <mika...@gmx.de> ---
This bug is still there in
Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3
I can confirm this:
I copy (^C) a table from Calc (including field names).
I paste the clipboard as new table.
There is no option to choose an existing field as primary key.
The only workaround is to allow the assistent creating an
generic ID field as primary key, then edit the database layout,
change primary key to wanted field. Save, close, reopen, then
delete the generic ID field created by the wizzard.
The suggested option to choose the primary key afterwards,
seems to work when you enter the design mode (key icon is
displayed in the right place), saving and closing gives no
error message.
But if you try to edit or add any values, you end up with
a seemingly write protected table, and most people would
never find out, that the yet missing primary key is the
reason for this.
Suggestion:
Please, extend the import GUI to allow selecting one of
your imported fields to be the primary key.
Please, double check after defining primary key and saving,
if this change could actually be commited.
Cheers
Mike
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
