[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to michael from comment #0)
> 
> - select an existing column to serve as the primary key (or multiple ones
> for a compound primary key)

This is already implemented: in Step 3 of the wizard you will see on the left
the columns. Now mark one (ore more by holding SHIFT) fields, right mouseclick
and set "Primary Key".

> - add a new column with an auto-incremented value to serve as the primary
> key (à la Access)

See the other bug descriptions for this. Importing from Calc doesn't allow to
create a new column at all at this moment. Importing with autovalue has never
worked, so it has been impossible to create a table with primary key and
autovalue for Firebird, because you couldn't change such a field in Firebird to
autovalue.

> - proceed without a primary key

This is already implemented. A popup appears when trying to save without
primary key, and asks, if a PK should be created. Pressing "No" will save the
table without PK. But Base will only read this tables in the GUI. There
couldn't be changed data through the GUI, only per direct SQL or macro.

-- 
You are receiving this mail because:
You are on the CC list for the bug.