Tom,
You are correct concerning the UNLOAD RELOAD procedure. Any ODBC tables that have common column names need to have aliases. I ran into that when trying to attach ACCESS tables. Also often the ODBC table columns show up as note fields without some formatting. As for deleting your specific table, that is over my head. I am not very familiar with the SYS tables. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, January 24, 2011 9:27 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Corrupt or invalid table Two issues with the LOAD. 1: The mentioned table is included in the UNLOADed structure file. So I need to confirm that it should not be included and that I should delete it out. 2: This database has several ODBC tables (64 total), none of which correctly connect back when loading the UNLOADED file. The process always errors out due to unsupported data types and unsupported column names in the foreign ODBC tables. I will have to develop a routine to properly attach all these ODBC tables before I can do a complete Unload / Load procedure. Surprisingly, this is no small task as many of the tables have 100+ columns. (However, it is a function I need to get completed one of these days.) So for now, I need confirmation that the suspect table Sys_Comment_ID indeed should be eliminated. Thanks, -Bob ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, January 24, 2011 9:06:20 AM Subject: [RBASE-L] - RE: Corrupt or invalid table Were you able to do an UNLOAD LOAD since the last corruption last week? That may tell you what the problem is. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, January 24, 2011 8:58 AM 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
