Dear Bill,
Unload the DB again and check all the CREATE and ALTER commands
to make sure that the column does not appear anywhere you don't expect. Also
look for a column with the same name and definition in another table. If you
can't find the problem, then just change the column definition and reload the
DB using the editied unload file.
Jason
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)
From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring
Sent: Wednesday, June 11, 2014 7: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]> [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]> [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
