Dan, You are correct. This table does show up in the explorer, I had not noticed it before. Hopefully there is a faster way to correct this as unloading each table individually will take a very long time. This data base has 122 tables and is not something I relish doing.
It also has a fair number of Sattached tables that have alias column names, which seems to prevent me from doing an UNLOAD ALL. (I would have to manually Sattach all the tables again, providing the column names) Does any one know if RScope fix this? Thanks, -Bob -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: "Dan Goldberg" <[EMAIL PROTECTED]> Every time my database got corrupt(has not happened in a while) it usually puts a sys_comment_id table in my database explorer but it should not show any sys tables. The way I fixed it is to unload each table and load it into a backed up working database. The sys_comment_id is a column. There might be a better way... Dan Goldberg From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, July 30, 2008 4:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Corruption continued.. I tried a reload, but the problem stays. I have not done an unload yet as I have a question... I have checked 4 databases and the three that do not have any issue do not have a table "Sys_Comments_ID". The database with the issue has this table and it is giving the error. Thus I suppose an Unload would copy the same table. 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? Thanks, -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441
