Thanks for the info. I will save it. I have had R:Scope but have not had time to learn how to use it.
Dan Goldberg -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Thursday, July 31, 2008 6:31 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Corruption continued.. 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. --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
