Hi Ed,
Why do you have emailg in more than one table?
Isn't that redundant?
Can't you reference it from the one table wherever you need it?
Bernie Lis
----- Original Message -----
From: Ed Rivkin
To: RBASE-L Mailing List
Sent: Saturday, December 19, 2009 2:17 PM
Subject: [RBASE-L] - RE: Challenge Redefining or Adding Field to Table
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, [email protected] 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.
[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
