Thankfully, I have not had this happen to me but there have been two or three people reporting tables turning mysteriously into views over the last few months.
One person can easily make a mistake - I do so often enough - but when a couple of others find the same thing then there has to be _something_ going on - whether it be collective hysteria or some weird "feature". Unusually perhaps <g>, I have no suggestions as to the cause and only the usual advice to keep good backups - tested by an occasional restore to check for errors! One thing I would say to Doug, though, is that I presume you have a good reason for adding & deleting rows from a permanent table with all the database space that creates? If not, a temp table would probably be a benefit from that point of view - but not without its own complications/needs. Regards, Alastair. ----- Original Message ----- From: "Ben Petersen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 09, 2002 10:10 AM Subject: RE: Top ten reasons... > What about everyone else?? Sorry ;-) > > On 9 Jul 2002, at 9:21, Doug Daily wrote: > > snip... > > Daily usage can be intensive. > snip... > > ================================================ > 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/
