Bill Do you have a computed column in Table B that refers to NycDocid2?
You could also project TableC FROM TableB USI ALL. Once this is done drop TableB. Try to rename the column if it succeeds then Rename TableC to TableB and recreate the index as necessary Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Wednesday, June 11, 2014 11:53 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Data Designer Question Javier, Sorry to say this is a single instance column name. I am trying to re-name it to a column name that already exists. That column is also a single instance column. After re-naming I would have 2 instances of the column name in 2 different tables. Table Column Name TableA NycDocId text (20) TableB NycDocId2 text (20) My problem manifests itself when I try to rename TableB.NycDocId2 to NycDocId Never had this problem before. Thanks, Bill From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Wednesday, June 11, 2014 11:03 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Data Designer Question Bill, Try running the command: BROWSE * FROM SYS_COLUMNS And click on the SYS_COLUMN_NAME header to sort the columns alphabetically and then find you columns name. If there is only one occurrence then you are back to square one; however, I am guessing that you might find more than one in which case you can make a note of the matching SYS_TABLE_ID. Run the command: BROWSE * FROM SYS_TABLES Click on the header of the SYS_TABLE_ID columns to sort it and the find the table ids and the corresponding tables names and you might find a duplicate columns name on the second table or view you forgot you had. I ran into something similar, once upon a time, and found a duplicate columns in a temporary/test table I had created previously and obviously forgot to delete. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Wednesday, June 11, 2014 6:59 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Data Designer Question Tony, Buddy, Albert The column affected is after the indexed column. I removed the index mentioned and saved the table. Then I tried to rename the column and, a different indexed column was included in the error message when I tried to save the column change. The data base was reloaded prior to this action. The column is not a primary or foreign key and not used in any views or used in a trailing computed column. I am still stumped and stuck with this error message, unable to rename a column name that I need changed, but I appreciate the help. Bill From: [email protected] [mailto:[email protected]] On Behalf Of Tony IJntema Sent: Wednesday, June 11, 2014 1:25 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Data Designer Question Bill, What also could be the case is that the indexed column which is mentioned is located in the table after the column you like to change. Remove the index - save table - and then try again to change the column size, and then rebuild the dropped index. Tony From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: dinsdag 10 juni 2014 20:03 To: RBASE-L Mailing List Subject: [RBASE-L] - Data Designer Question Using latest version RB-95-64. I am changing the schema in a table. I want to change a column's name and length (ColNameAAA text 16) to (ColNameBBB text 20). The column involved is not used in another computed column nor is it indexed. When I click on save, I get the error message "Column ColNameXXX is indexed and may not be altered (1143)", which refers to another column in the table which is indexed. Does anyone know what generates the error message and why it is there in the first place ? Thanks, Bill Eyring
