Dick, I don't know of any reasons why you couldn't add a column without removing indexes and computed columns; I do it all the time without any problems. It might be time to do a database rebuild using the RELOAD or UNLOAD ALL options.
Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Carpet Broker, Dick Fey Sent: Wednesday, January 06, 2016 9:29 AM To: [email protected] Subject: [RBASE-L] - RE: Add columns to a table Bruce; It is 9.5 networked Data designer. Finally gave up, deleted all indexes and the one computed column, made changes and fixed indexes and computed col. All is good. I just could not understand why I could not even change the name of an existing unused column till I cleared all the indexes and computed columns. Dick Fey On 1/5/2016 6:51 PM, Bruce A. Chitiea wrote: > Dick: > > 1. Which version and build? > 2. Standalone or Networked? > 3. Data Designer, or ALTER TABLE? > > Bruce Chitiea > dbtcca/director/member-at-large > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Carpet > Broker, Dick Fey > Sent: Tuesday, January 05, 2016 11:38 AM > To: [email protected] > Subject: [RBASE-L] - Add columns to a table > > I am trying to add a couple of columns to an existing table that has computed > and indexed columns. It would appear I have to change those to no compute > and no index to do so. Is that the only way ? > The additions have no bearing on the computed or indexed columns. > > -- > Dick Fey > Carpet Broker Inc > P: 913-894-9211 > F: 913-894-0138 > > > > -- Dick Fey Carpet Broker Inc P: 913-894-9211 F: 913-894-0138
