[RBASE-L] - RE: Challenge Redefining or Adding Field to Table

[Ed Rivkin]

Emmitt, Thanks either I am missing something or wasn't specific enough. Opendyear isn't the column I am trying to alter. It is a calculated field that is in the table with the column that I am trying to alter.  The column I am trying to alter is: emailg text 24 and I want to alter it to emailg text 34. Regardless if I rename the other occurrences of emailg and then attempt to change it in the remaining table OR add a new column such as: New text 34, I get the same error messages;   -ERROR- As column OpenDYear is used in another table, its type cannot be redefined. (2942)   -ERROR- Unable to create/modify table. (2832) Ed Dec 19, 2009 12:44:23 PM, rbase-l@rbase.com wrote: Ed, It sounds like there’s still one table out there with the same column name. Try: LIST COLUMN OpenDYear And see what pops up. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. emmitt.d...@everpack.com (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f emmitt.w.d...@comcast.net From: rbase-l@rbase.com [mailto:rbas...@rbase.com] On Behalf Of Ed Rivkin Sent: Saturday, December 19, 2009 1:21 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Challenge Redefining or Adding Field to Table Hi Folks, I want to expand a 24 char text field to 34 chars but am running into a few problems. The field is used in multiple tables so I first renamed the field in the other tables. When I then try to alter the column in the remaining table, I am getting the following error messages which refer to a calculated field in the table. -ERROR- As column OpenDYear is used in another table, its type cannot be redefined. (2942) -ERROR- Unable to create/modify table. (2832) Opendyear is defined as (iyr(opend)) and works fine in the table. I also tried adding another text field with a 34 char length and got the same messages. Thinking the DB somehow became corrupted, I tried Autochk, R:Scope, and Unload/Reload and all were clean. As always thanks for your thoughts and assistance. Ed