Razzak: Thank you for a well-constructed reply.
I ran an experiment using RBDEFINE, validated by R:Documenter, which checked all the boxes in this case for ad hoc, incremental changes. Flawless. This particular case is one of catching myself in early-stride before I code over-much. Global search and replace on an unloaded COPY of the database structure should do the trick. Thanks again, Bruce Chitiea 909.238.9012 cell On Sep 6, 2013, at 15:25, "A. Razzak Memon" <[email protected]> wrote: > At 05:47 PM 9/6/2013, Bruce A. Chitiea wrote: > >> Is there a way to code these key-column name changes (e.g. something like >> ALTER TABLE with an index override)? > > > Bruce, > > The simple answer, No. > > Preserving Referential Data Integrity is among the strengths of R:BASE! > > You must follow the rules and the process using the Graphical Data Designer, > (RBDefine) where everything is validated before finalizing changes, etc. > > Having said that, depending on the number of tables, columns, and associated > indexes, you can UNLOAD the database STRUCTURE only to a file, carefully edit > the file using R:BASE Editor and then re-built the database SCHEMA again. > > During the build process every referential integrity is checked. > > Caution: > > Manually modifying the R:BASE database structure file requires the in-depth > knowledge and understanding of R:BASE schema, syntax, and relationship. > > The new and enhanced Graphical Data Designer (RBDefine) in R:BASE eXtreme > 9.5 (32/64) is designed and intended to avoid human error(s), and keeping > everything in perspective and true-relational. > > Hope that helps! > > Very Best R:egards, > > Razzak. > > www.rbase.com > www.facebook.com/rbase > -- > 30+ years of continuous innovation! > 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! > -- > >
