Thanks Razzak, I will give it a try tonight. -Bob
-- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: "A. Razzak Memon" <[EMAIL PROTECTED]> > At 07:02 PM 7/30/2008, [EMAIL PROTECTED] wrote: > > >RScope sees this table and reports : > > > >The width in two byte words of each row for table SYS_COMMENT_ID > >is set to 1 in the structure file. It should be within the range > >of 2 to 2100. > > > >Is this a valid table? > > > >Any thoughts? > > Bob, > > R:Scope 7.5 or R:Scope 7.6 can indeed fix this structural error. > > Here's how: > > With your reported error; > > The width in two byte words of each row for table SYS_COMMENT_ID > is set to 1 in the structure file. It should be within the range > of 2 to 2100; > > the problem is that the row size(s) for the SYS_COMMENTS table > is outside the valid range. > > To repair the corruption, > > 01. First make a backup copy of the database. > > 02. Launch R:Scope 7.5/7.6, and connect to the corrupted database. > > 03. From the menus, select "Fix" > "Columns" > > 04. Select "SYS_COMMENTS" from the list. > > 05. The available columns, SYS_COMMENT_ID and SYS_COMMENT will be > displayed. > > 06. Here, starting with SYS_COMMENT_ID, verify the following: > > Location in Row (2 Byte Words): 1 > Data Type: 1 > Length: 1 > Scale: 0 > > 07. If any values are different than what is listed above, > make the appropriate changes and save the changes. > > 08. Next, viewing SYS_COMMENT, verify the following: > > Location in Row (2 Byte Words): 3 > Data Type: 8 > Length: 1 > Scale: 0 > > 09. If any values are different than what is listed above, > make the appropriate changes and save the changes. > > 10. Now, run the "Check Structure" options in R:Scope for > the SYS_COMMENTS table. Zero errors should be reported. > > 11. Lastly, to verify the entire database integrity, check > all the tables. > > That's all there is to it! > > Very Best R:egards, > > Razzak. > >
