Try reloading the database. It sounds as if your RX3 file has problems.
If not resolved by the reload, try dropping the index that is reporting
the error and then reassigning it.
Albert
On 6/10/2014 12:03 PM, Bill Eyring wrote:
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
