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
