Randy From code - DELETE ROWS FROM tablename WHERE PKcolumnname=whatever
Ian At 13:55 28/09/2001 -0400, you wrote: >Ian, > > How are the records deleted. Is this done from a form, from a > prompt, or >from the edit screen? > > Randy Peterson > >Ian Stone wrote: > > > I have this problem, been trying to get to the bottom of it for over a year > > now. Hoped it would go with windows 6.5++. It is always the same > > table. It started with a PK on a computed column, I changed the computed > > column for a real column to no avail. Even tried a unique key, again still > > got the problem. > > > > What happens is the index gets corrupt during the normal working day in > > multi user mode. Records are only deleted from the table. Overnight in > > single user mode records are added to the table using code to check > > for duplication by checking the key column, as this is indexed and the > > index is corrupt the check fails adding a duplicated record to the > > table. Again overnight, a reload takes place which works but also > > maintaining the corrupt index. If you watch the reload running you see a > > duplicated record error appear. After a reload the column is still > > described as being indexed. > > > > Ian > > > > At 16:28 27/09/2001 -0700, you wrote: > > >I do lock the table & if the table won't lock, then someone has some > type of > > >lock (usually an edit lock) so it informs the user to have others in the > > >dept to exit the table and then the user can try the program with the > append > > >operation again. It appears that the index problem exists BEFORE the > append > > >is attempted. Trying the append just reports that there is an indexing > > >problem. As users, throughout the day add/edit rows in the accounting > > >table, the indexes will get updated, thus, the indexes for this table (as > > >well as many other tables) are in a constant state of flux. > > > > > >I have indexes on computed columns in other tables that are accessed by > > >everyone and haven't had problems with those tables. > > > > > >My questions again are: What can cause the corruption of the indexes > on the > > >table and how can I discover which index or indexes on the table are > > >corrupted. > > > > > > > > > > > >-----Original Message----- > > >From: Troy Sosamon [mailto:[EMAIL PROTECTED]] > > >Sent: Thursday, September 27, 2001 9:09 AM > > >To: [EMAIL PROTECTED] > > >Subject: RE: Index corruption > > > > > > > > >Try putting a lock manual on the table before you do the append and then > > >take it off. > > > > > >set lock tablename on > > > > > >append..... > > > > > >set lock tablename off > > > > > >Troy
