Issue 113453 - After setting more columns as primary key, can't open and update data of the table
Summary: After setting more columns as primary key, can't open and update data of the ...
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.2.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://user.services.openoffice.org/z...
Keywords:
Depends on:
Blocks: 84405
  Show dependency tree
 
Reported: 2010-07-27 07:26 UTC by amy2008
Modified: 2013-02-07 22:42 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
test database with combined keys (4.85 KB, application/vnd.sun.xml.base)
2010-07-27 11:03 UTC, r4zoli
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description amy2008 2010-07-27 07:26:31 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
Comment 1 amy2008 2010-07-27 07:28:24 UTC
url
Comment 2 r4zoli 2010-07-27 11:02:40 UTC
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.
Comment 3 r4zoli 2010-07-27 11:03:37 UTC
Created attachment 70842 [details]
test database with combined keys
Comment 4 amy2008 2010-07-28 03:06:01 UTC
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.