At 10:03 AM 8/1/2015, Bill Niehaus wrote:
TrialPlot is a column that adds a text and integer column together with
this formula (Trial+(CTXT(PlotNum))) and it is indexed.
When I try to drop the index on that column, I get the same error that
Column TrialPlot is indexed and may not be altered.
Bill,
While in Data Designer (RBDefine), after dropping the INDEX, make sure
to save the table and close the Data designer. Then, open the designer,
add the column, save the table, add the INDEX and then close the data
designer. See how that goes.
Alternatively, you can use the following command at the R> prompt and
see what you get.
SET MESSAGES ON
SET ERROR MESSAGES ON
ALTER TABLE tablename ADD COLUMN columnname datatype
If all fails, send me the database/table schema and I will tell you
what is wrong with your table.
I am hoping that you have downloaded the latest build: 9.5.5.20730.
Feel free to reach out to me with any questions.
Very Best R:egards,
Razzak.
www.rbase.com
www.rbaseX.com
www.facebook.com/rbase
--
32 years of continuous innovation!
17 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
