Disk tables are regular table, where as, temporary tables are memory tables. The listing of the RBase version, OS and network give clues to the problem. In many cases changing the method used to get the results avoids the problem and may give a clue to the original problem. RRR
----- Original Message ----- From: "mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 4:54 PM Subject: Re: Top ten reasons... > These aren't temporary tables....they are just plain old regular tables, that > get a few rows inserted now and then. But somehow, these tables are turning > into views...ie some sort of corruption!!!!! > > Mike > > Ron Rose wrote: > > > Generally, if the temporary disk tables are to have zero records at the end > > of the day, dropping these and creating new ones is much cleaner database > > operation. > > Is there some reason you need to DELETE? > > RRR > > > > ----- Original Message ----- > > From: "mike" <[EMAIL PROTECTED]> > > To: "Rbase List" <[EMAIL PROTECTED]> > > Sent: Monday, July 08, 2002 1:10 PM > > 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/
