At 02:17 PM 12/19/2009, Ed Rivkin wrote:
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,
It seems that you have a database structure that has been either converted
or upgraded from a legacy version. Now that you are trying to modify the
schema using the Data Designer of latest R:BASE versions, all data integrity
rules are enforced before saving the structure. That is the reason you are
seeing all those -ERROR- messages.
In order to check the integrity of your database, I suggest that you do
a complete UNLOAD, and then re-build the database. This single step alone
should provide you with all checks and balances. During the process of
re-building the entire database, you will be able to see and identify all
-ERROR-s. You must correct all identified errors accordingly.
Having said that, when was the last time you re-built the entire database
using the UNLOAD/LOAD approach?
This is the first and most important step to check the integrity of your
database. The bottom line, how healthy is your database?
For step-by-step instructions, you may refer to "Database Maintenance"
articles specific to your version of R:BASE.
From The Edge: http://www.razzak.com/fte/
You may also search for "How Healthy is Your Database?" in the archives
of this R:BASE list for more tips, techniques, and discussions on this
topic.
Hope that helps!
Very Best R:egards,
Razzak.
