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? Mike
________________________________ From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Saturday, July 20, 2013 3:41 PM Subject: [RBASE-L] - Re: Autochk query (and an unrelated mysteriousfix) At 01:27 PM 7/20/2013, Alastair Burr wrote: > ... what is causing me the real problem is that RELOAD exits with these > errors and sets the ErrVar to the error number. > > R>reload xxx > -ERROR- Table SYS_COMMENTS has an incorrect number of rows. ( 450) > -ERROR- Table SYS_DEFAULTS has an incorrect number of rows. ( 450) > -ERROR- Table SYS_COMPUTED has an incorrect number of rows. ( 450) > -ERROR- Table SYS_CONSTRAINTS has an incorrect number of rows. ( 450) > Finished reloading with 4 error(s). > RELOAD operation is complete > > Any thoughts? 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. 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! --
