Back in my 2.11 days I had this exact problem. But only when I did a "delete rows from table where count > 0". It never happened when I would delete > 1.
No problems since then, but I use temp tables for that routine now. Kenny ----- Original Message ----- From: "Bernie Corrigan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 09, 2002 3:37 PM Subject: Re: Top ten reasons... > Ron - > > Your assumption is incorrect. The temporary tables are written > to disk in $$$ files. > > Bernie > -------------------------------------- > At 01:29 PM 7/9/2002 -0700, you wrote: > >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/ > > > > ================================================ > 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/
