Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From:    [ Add a report in this area ]  
Report #:  53393   Status: Closed
Adding duplicate column names not detected when entered
Project:   Build #:  11.0.2804.9245
Version:    11.0 Submitted By:   David Clegg
Report Type:  Minor failure / Design problem Date Reported:  10/13/2007 2:16:56 AM
Severity:    Commonly encountered problem Last Updated: 3/20/2012 2:24:39 AM
Platform:    All platforms Internal Tracking #:   255808
Resolution: Fixed (Resolution Comments) Resolved in Build: : 11.0.2844.9692
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
Adding a column with a duplicate name is only detected when closing the Table Design tab, giving no opportunity to fix, and losing all other changes made to the table schema.
Steps to Reproduce:
- Switch to Data Explorer
- Expand the 'Ado.Net' node
- Right-click on the 'BlackfishSQL Remote Provider' node and select 'Add New Connection'
- Enter 'DataTest' in the 'Connection Name' field
- Right-click on the 'DataTest' node and select 'Modify Connection'
- Enter 'sysdba' in the 'User Name' field, 'masterkey' in the 'Password' field, and 'D:\Data\DataTest.jds' in the 'Database' field
- Click the 'Test Connection' button
- Click 'Yes' when prompted to create the database
- Click the 'OK' button to confirm database creation
- Click the 'OK' button to close the 'Add Connection' dialog
- Expand the 'DataTest' node in Data Explorer
- Right-click on the 'Tables' node and select 'New Table'
- Enter 'Field1' in the 'Name' column and press the down arrow
- Enter 'Field1' in the 'Name' column and press the down arrow
- Right-click on the 'Table Design:DataTest' tab and select 'Close Page'
- Click the 'Yes' button when prompted to save changes

Expected: You are prompted about the duplicate field names, and are given an opportunity to address the problem.
Actual: You are prompted about the duplicate field names, but the tab is closed, losing all changes.
Workarounds
None
Attachment
None
Comments

None

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.