To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=57154
Issue #:|57154
Summary:|Table Wizard: adding a field by hand confuses the
|wizard
Component:|Database access
Version:|OOo 2.0
Platform:|PC
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P2
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|ydamyanov
------- Additional comments from [EMAIL PROTECTED] Tue Nov 1 12:30:30 -0800
2005 -------
When trying to add a field by hand in the Table Wizard, the second pane shows
the field name changed and shows the default type instead of the custom-selected
type. To increase confusion, after finally creating the table, the field appears
with the default name 'field' unchanged, but with the proper user-selectred
type.
Steps to reproduce:
1. Connect to an (empty) mysql database using either JDBC ot ODBC. For this
report I use ODBC. (My mysql server is remote, 4.0.22 for Linux, my mysql ODBC
driver is 3.51 for Windows).
2. Start creating a new table using the Table Wizard. Use e.g. FirstName,
LastName and PhoneNumber of the "Employees" sample table.
3. Click "Next" and try to add a new filed using the "+" button:
-- change the name from "field" to "id"
-- change the type into "Integer [integer unsigned auto_increment]"
4. Click "Next" and go to the next pane. Now:
==> bug #1: go back to the previous pane and you will dicover that the type of
the field is again "Text [....]" (or at least the UI shows it that way!)
-- Now click "Next" again and try to define that filed as a primary key:
-- Click "Use an existing field as a primary key"
-- Open the drop-down menu for the Fieldnames... surprise!
==> bug #2: you see a field named 'field' and not 'id'.
5. After finalizing the table, you will see that the field name is the wrong
'field' (instead of 'id') but the type is correct ("Integer [integer unsigned
auto_increment]") -- the opposite of what the second pane of the Wizard was
showing.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
