At 10:25 PM 7/22/2013, Michael J. Sinclair wrote:
Will this procedure destroy forms and reports made in Rbase for DOS if the user still needs to access the database with Rbase for DOS?
Nope! Using the R:BASE eXtreme 9.5, UNLOAD ALL command will unload everything including DOS Forms (SYS_FORMS), DOS Reports (SYS_REPORTS), DOS Labels (SYS_LABELS), 6.5 Win Forms (SYS_FORMS2), 6.5 Win Reports (SYS_REPORTS2), and 6.5 Win Labels (SYS_LABELS2), if any. The re-build process will put everything back in those tables again. FWIW ... You all should make an effort to take advantage of R:BASE eXtreme 9.5 built-in convert process to convert all your DOS Forms, Reports, and Labels to 9.5 (32/64) for Windows. It is as easy as 1-2-3. We have built many amazing tools in R:BASE eXtreme 9.5 to help you all migrate from R:BASE for DOS to 9.5 (32/64) for Windows and then take advantage of all new features and enhancements. Not to mention the full compatibility with MS Windows 7 (64) Pro and MS Windows 8.x (64) (Pro). Very Best R:egards, Razzak.
Alastair, Got R:Scope 9.5 (32/64)? If not, UNLOAD and then Re-Build the database and see what you observe. Here's a very simple exercise to check the health/integrity of the database. Note: Make a backup copy of your database before following the steps below. -- At the R> Prompt SET MESSAGES ON SET ERROR MESSAGES ON DISCONNECT CONNECT dbname IDENTIFIED BY owner password OUTPUT ABC.ALL UNLOAD ALL OUTPUT SCREEN DISCONNECT RENAME dbname.rb? dbbackup.rb? -- 9.5 (32) RENAME dbname.rx? dbbackup.rx? -- 9.5 (64) SET FEEDBACK ON RUN ABC.ALL SET FEEDBACK OFF Watch the database being re-build right in front of your eyes. Notice any -ERROR-s, if any, and handle those specific items accordingly. With a corrupted database schema or data, you may check the health/integrity of your database using the two-step process as follows: -- Step 01 (Unload Database Schema) DISCONNECT CONNECT dbname IDENTIFIED BY owner password OUTPUT ABC_STRUCTURE.ALL UNLOAD STRUCTURE OUTPUT SCREEN -- Step 02 (Unload Actual Data) OUTPUT ABC_DATA.ALL UNLOAD DATA OUTPUT SCREEN DISCONNECT RENAME dbname.rb? dbbackup.rb? -- 9.5 (32) RENAME dbname.rx? dbbackup.rx? -- 9.5 (64) -- First Re-Build the Database Schema CLS RUN ABC_STRUCTURE.ALL Watch the database schema being re-build right in front of your eyes. Notice any -ERROR-s, if any, and handle those specific items accordingly by manually editing the ABC_STRUCTURE.ALL file. Make sure to delete the dbname.rb? or dbname.rx? prior to running the ABC_STRUCTURE.ALL again. Repeat this step until you have a perfect database database schema with no -ERROR-s using the TRACE option as follows: CLS DISCONNECT DELETE dbname.rb? -- 9.5 (32) DELETE dbname.rx? -- 9.5 (64) TRACE ABC_STRUCTURE.ALL Make sure to delete the dbname.rb? or dbname.rx? prior to TRACing the ABC_STRUCTURE.ALL again. -- Once the database schema is built with no errors, then load the data CLS SET FEEDBACK ON RUN ABC_DATA.ALL SET FEEDBACK OFF Hope this simple exercise/steps provides you with some blue's clues! Very Best R:egards, Razzak. <http://www.rbase.com/>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! --
