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
