Dear Bill.....I believe you are correct...it was me! I think somebody else at that mentioned the part about the table getting turned into a view, but I can't remember who. Will try ALL of the suggestions before creating the temporary table solution.
Mike Bill Downall wrote: > I think Mike Sinclair started the same topic in April, under the heading > "disappearing tables." I remembered the thread, too, and wondered if this was > the second person to have the problem, but it looks like it's the same person > reporting it for the second time. Mike, could that be what happened? > > Since it appears Mike's is still the only database with this particular problem, I > am suspicious that it is one of three things: 1) an application problem: drop > table and/or create view commands hidden somewhere that Mike has forgotten > about and/or not found. 2) a hardware problem. I'm serious. If, for example, > there were a coded piece of information in the tables block of the #1 file with a > one bit difference between a designation of a table and a view, then a bad pin on > a NIC or cable could lead to information being changed in the #1 file. (I have > seen, for example, a table name change with a letter being changed to another > letter that was 2, 4, 8, 16, 32, or 64 ascii numbers lower.) 3) Something really > unusual about the database or application, like a reserved word problem, that is > resulting in this corruption. > > In any case, sending a copy of the before and after databases to RBTI > ([EMAIL PROTECTED]) is probably the best idea. > > Bill > > On Tue, 09 Jul 2002 14:15:52 -0400, mike wrote: > > >Dear Alastair, > > > >Do you recall who else had this happen? I have been searching but I can't find > >them! > > > >Mike > > > >Alastair Burr wrote: > > > >> 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. > >> > > ================================================ > 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/
