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
