https://bugs.freedesktop.org/show_bug.cgi?id=64377
--- Comment #2 from Biju <[email protected]> --- Please Note (In reply to comment #1) > I wouldn't prefer an automatically added and hidden primary-key-field. The request is not asking to add hidden primary-key-field. It is asking "add a hidden ROWID field", which "act like a primary key field" at certain times. may be some thing similar to what Oracle have. Only problem in Oracle is there is no guaranty that ROWID of a record stay constant for the life time of the record. It changes when we/system reorg a table. > When you create a table without a primary-key a dialog in Base appears: > "No primary key ... you can only enter data with a primary key ... should > the primary key created now?" Not much help for a new bee. Basically most first time users dont understand the concept of primary key, foreign key, and relational integrity. > The only bug in this moment is: It isn't possible to add a primary key in an > existing table without primary key while using the GUI. No, I dont think you need to force user to create a primary key all the time. Oracle, MS-SQL, MS-Access dont do that. Still corresponding GUI tools like SQL-Developer, TOAD, SQL-Server Management Studio, and also I think MS-Access allow user to edit the table content. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
