Issue 10822 - [RFE] Primary Key Assignment Dialog needs improving ?
Summary: [RFE] Primary Key Assignment Dialog needs improving ?
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: PC Other OS
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 55184 (view as issue list)
Depends on:
Reported: 2003-01-21 09:09 UTC by alex.thurgood
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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. ***