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
