Apache OpenOffice (AOO) Bugzilla – Issue 113453
After setting more columns as primary key, can't open and update data of the table
Last modified: 2013-02-07 22:42:01 UTC
Can reproduce it in OOo3.2.1 on Windows and Linux, works well in OOo 3.2 How to reproduce it 1. Open a new Database file 2. Create Table in any way, as if there are five columns (c1,c2,c3,c4,c5) 3. Set c1 and c2 as Primary key, then save the table and close Table Design mode 4. Open the table, then enter some data in each columns, then close Table Data View 5. Reopen the table, and try to update the data in table Result Can't update the data in table Expectation Can update and save the data in table successfully Regards Li Meiying
url
What data type you used in PK? I used OOo 3.2.1 en_US and hu_HU version on Hungarian win7. I tested with text(for c1 and c2) and integer(for c1 and c2) data type. And I can open both, and add data after closing table data view. I downloaded example file from forum, and I can add data in Table data view. I opened example file in OOO330_m1 en_US version and no problems with tables. May be it is zh specific issue.
Created attachment 70842 [details] test database with combined keys
Data type for c1 and c2 is text or interger, it comes to the same result. I tested in OOo 3.2.1 en_US on Wins and Ubuntu.