I remember having all sorts of problems with those pesky error tables. The guys at [EMAIL PROTECTED] also told me to "autochk" and "unload" "reload" the DB. I didn't have any PK or FK though... You may want to fire them an e-mail if you still have problems.
~Claudine :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Fogelson, Steve Sent: Thursday, August 01, 2002 12:16 PM To: '[EMAIL PROTECTED]' Subject: RE: Database problem Claudine, Thanks for the reply. Renamed and it still locks up when I try to delete. Steve -----Original Message----- From: Claudine Robbins [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 11:41 AM To: [EMAIL PROTECTED] Subject: RE: Database problem I had this happen to me once. Number-named tables need to be "renamed" before "deleting". Hope that helps. ~Claudine :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Fogelson, Steve Sent: Thursday, August 01, 2002 11:33 AM To: R:Base User Group (E-mail) Subject: Database problem Running R:Base 6.5++ (1.851xRT03) on a Windows 2000 Pro Work Station. I added a field to a table1. When saving table1, R:Base locked up. When I restart and open up that DB, I see an extra table2 with a name of numbers. Table2 is exactly the same as table1 except it does not have the additional field. I tried to delete table2 and it could not because another table3 uses the id of the table1 or table2 as a foreign key. I deleted the FK in the table3 and then the field in table3 that references the id of table1 or table2. Tryed to save. R:Base locked up. Now when I restart I have 2 extra files. Help!!! Steve Fogelson Internet Commerce Solutions ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
