Or the column name may be used in a view. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293
________________________________ From: Emmitt Dove <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Sat, December 19, 2009 12:42:37 PM Subject: [RBASE-L] - RE: Challenge Redefining or Adding Field to Table 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. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From:[email protected] [mailto:[email protected]] 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
