Issue 20673 - Chengin column name while copying a table
Summary: Chengin column name while copying a table
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: christoph.lukasiak
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks: 20748
  Show dependency tree
 
Reported: 2003-10-03 20:03 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 Unknown 2003-10-03 20:03:37 UTC 
I've got a DSN connection with a flat file (.cvs) (It's this one: http://ip-to-
country.directi.com/node/view/6) and I've got an ODBC connection with a 
Microsoft Access database.

In the database navigation (F4) I attempted to copy (dragg and drop) the flat 
file table (.cvs) from the flat file datasource to the ODBC datasource. This 
way I was hoping to create an Access table with the information in the .cvs 
file.

The Copy Table dialog appears and everything goes well untill I reach the Type 
formatting section. Here I want to change the standard columnnames (C1, C2, C3 
etc) into something more understandable. I enter my prefered columnname in the 
Field name field. Then when I move away from that field (Either with Tab or by 
selecting the next column) I get an error message saying:


Warning!

The table cannot be saved because column name "my_column_name" was assigned 
twice.


I tried different (unique) names but the message keeps showing up.
Comment 1 Frank Schönheit 2003-10-06 07:32:29 UTC 
fixed in CWS fs002
Comment 2 Frank Schönheit 2003-10-06 07:33:13 UTC 
argh. Wrong action taken, re-opening
Comment 3 Frank Schönheit 2003-10-06 07:33:29 UTC 
correcting sub component (see
http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access,
please), and default owner
Comment 4 christoph.lukasiak 2003-10-06 11:21:23 UTC 
CLU: i can repro that in 680m7

1. create a text and an access odbc data source
2. copy table from text to access ds and change a field name

-> error message: table cannot be saved because column name was 
assigned twice
Comment 5 christoph.lukasiak 2003-10-06 11:24:47 UTC 
.
Comment 6 christoph.lukasiak 2003-10-06 11:26:20 UTC 
.
Comment 7 Frank Schönheit 2003-10-06 13:28:16 UTC 
fs->oj: your dialog
Comment 8 hans_werner67 2004-02-02 12:16:49 UTC 
change subcomponent to 'none'
Comment 9 ocke.janssen 2004-05-27 15:49:13 UTC 
Fixed in cws insight01
Comment 10 marc.neumann 2004-06-16 12:43:47 UTC 
reopen
Comment 11 marc.neumann 2004-06-16 12:44:04 UTC 
reassign to clu
Comment 12 marc.neumann 2004-06-16 12:44:22 UTC 
fixed in cws insight01 -> please verify
Comment 13 christoph.lukasiak 2004-06-16 16:16:52 UTC 
verified in cws insight 01
Comment 14 christoph.lukasiak 2004-08-11 14:28:02 UTC 
verified in master (680m50-8)
Comment 15 christoph.lukasiak 2004-09-07 09:08:54 UTC 
CLU->mediawave: please verify - versions here:
http://download.openoffice.org/680/index.html