You are correct Ben! These are NOT TEMPORARY TABLES! They are regular tables that get used everyday, but have no rows in them by the end of the day. For each table that has disappeared and turned into a view, I have created a file called ....tablename.str. After the table disappears, if I type LIST tablename, Rbase acts like there is no such table. But if run the file to recreate the table, it fails....cuz it is a duplicate table name! So....to fix it, I type DROP tablename, then RUN tablename.str and voila...everything is back to normal...except my brain! If all else fails, I can rewrite the code to use temporary tables, and recreate them as needed, but just like Ben said.....I would rather know what is going on before I create a work around.
Mike Ben Petersen wrote: > Not to answer for Mike (but I guess I am <g>), these aren't > temporary tables, but regular tables that hold data temporarily. I'm > really curious to know what could cause this to happen so I don't > go there. You would think that if this were hardware related there > would be more corruption in more areas rather than this one > strange thing that only affects regularly emptied tables, but then, > who knows :( > > Ben Petersen > > On 9 Jul 2002, at 7:38, Dan Goldberg wrote: > > > I have never seen this happen. I create and drop temporary tables all day > > long without a hitch. > > > > Things to try: > > > > > > 1. If it is on one machine, I would try a clean install on another machine > > to duplicate it. > > > > 2. I would r:scope the database. > > > > 3. If the database is being used over a network, try it on the local > > machine. > > > > 4. Close all programs on the machine including any Norton > > utilities/anti-virus programs. > > > > 5. Do a scandisk on the computer. > > > > Dan > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > > Behalf Of mike > > Sent: Monday, July 08, 2002 1:11 PM > > To: Rbase List > > Subject: Top ten reasons... > > > > > > Ok wizards....one of my tables (called archdet2) disapperared. I looked > > in the system table call SYS_TABLES and I found it...but it had been > > changed into a view! I tried to change the column called SYS_TABLE_TYPE > > from VIEW to TABLE, but Rbase would not allow it. So.........what are > > the TOP TEN REASONS that this might happen? It was easy to fix, but it > > happens a lot. My database is getting pretty big (about 500 meg for all > > 4 files). Strangely, it happens to several different tables, but they > > all have 1 thing in common.....they only store rows temporarily.....they > > all have zero rows at the end of the day (the app deletes all the rows > > after the table gets used). These are NOT temporary tables! > > > > Any ideas? > > > > Mike > > > > ================================================ > > 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/
