Issue 10822 - [RFE] Primary Key Assignment Dialog needs improving ?
Summary: [RFE] Primary Key Assignment Dialog needs improving ?
Status: CONFIRMED
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:
URL:
Keywords:
: 55184 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-01-21 09:09 UTC by alex.thurgood
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

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 
Hi,

according to http://development.openoffice.org/releases/Target_Milestone.html
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.

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

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