SYS_COMMENT_ID is a valid column in the SYS_COMMENTS table. SYS_COMMENT is the other column in the table.
Are you sure that you are seeing what you think you are seeing? Your SYS_COMMENTS table may be empty if you never add comments to your table definitions. Regards, Alastair From: [email protected] Sent: Monday, January 24, 2011 2:57 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Corrupt or invalid table I seem to have a corrupt or invalid table in my database. R>list table sys_comment_id Table: SYS_COMMENT_ID No Lock(s) Triggers: No. Column Name Attributes --- ------------------ ------------------------------------------------------ 1 SYS_COMMENT_ID Type : INTEGER Index : SINGLE-COLUMN Current number of rows: 0 I am assuming that this "sys_comment_id" table is not correct. I had a database corruption last week and another this morning. I suspect it has to do with something related to this possibly errant table. Seems like I have seen this on the list sometime in the distant past. (version 7.5) Any suggestions? Thanks, Bob
