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/
