Issue 10822

Summary: [RFE] Primary Key Assignment Dialog needs improving ?
Product: Base Reporter: alex.thurgood
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.0.1   
Target Milestone: ---   
Hardware: PC   
OS: Other OS   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description alex.thurgood 2003-01-21 09:09:48 UTC
Some system info :

Linux Mandrake 9.0, MySQL 3.23.52 Max, latest MyODBC 3.51.05

If you create a table in the gui without
setting a field as primary key, it will propose to do so for you. It
does this by creating an "Int auto_increment make primary" statement,
which is all very nice, but the table will not be written if you already
have an auto_increment field defined and of course you get a message
from the driver saying that the table couldn't be created because you
can't have more than one autoincrement field. It would be nice if when
the dialog pops up you could choose the field that you want to have the
primary key. At the current time, I couldn't see anyway of doing this
other than by saying no at the dialog and manually adjusting my
auto_increment field via the gui. Feature enhancement ?
Comment 1 Frank Schönheit 2003-01-21 13:20:56 UTC
confirming as valid RFE (does not necessarily mean that we start
implementing it tomorrow :)
Comment 2 Frank Schönheit 2003-09-10 15:00:28 UTC
fs->oj: If we really do this, then it's most probably up to you ...
Comment 3 ocke.janssen 2003-09-22 10:35:29 UTC
Comment 4 marc.neumann 2003-10-15 09:44:17 UTC
Comment 5 hans_werner67 2004-02-02 13:04:26 UTC
change subcomponent to 'none'
Comment 6 marc.neumann 2004-04-28 12:47:23 UTC

according to
retarget to OOo_Later

Bye Marc
Comment 7 alex.thurgood 2006-08-20 18:26:26 UTC
I might add (if I haven't done so already), that I can update and modify my data
from the Mac to the remote mysql server using CocoaMySQL without any problems.

Comment 8 alex.thurgood 2006-08-20 18:27:46 UTC
Ignore that last comment, it was intended for another issue, sorry.

Comment 9 ocke.janssen 2009-03-20 13:47:16 UTC
*** Issue 55184 has been marked as a duplicate of this issue. ***