Razzak, I thought this would be a good time to thank you for pointing me to the importance of database maintenance over a year and a half ago when we first changed over to 7.6. I do that almost every week now and have not had errors for quite some time. It is a nice feeling to have a fresh, clean database to work with. I would urge Ed to take that advice.
Have a Merry Christmas. Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Saturday, December 19, 2009 2:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Challenge Redefining or Adding Field toTable 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.
