At 10:29 AM 1/6/2016, Carpet Broker, Dick Fey wrote:
Finally gave up, deleted all indexes and the one computed column, made changes and fixed indexes and computed col. All is good. I just could not understand why I could not even change the name of an existing unused column till I cleared all the indexes nd computed columns.
FWIW ... 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. www.rbase.com www.facebook.com/rbase -- 33 years of continuous innovation! 18 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
