Hi

Here is my problem, I'm using a view (no one else is using the tables or DBC, etc).
Every time I begin to delete records in a determined 'sequence' certain record doesn't get deleted, from my code the record is supposely deleted already. This is what I apply before I want to delete a record:


IF !DELETED(RECNO())


This is weird 'cuz the record does gets deleted if don't apply the 'sequence' of 'deletes'.
I think the 'sequence' itself means nothing as I'm testing the code against an 8 records table and the whole idea itself doesn't make any sense at all.
I also make sure that the pointer is in the right record before I try to delete it, but even so I can't make it work.
One thing that is important to me is to use a code similar to the one above as this view probably is going to be used for more users, I guess this is good way to check whether the record is already deleted, but in case this is not always effective could you show a better way.

What could be wrong?

Thanks in advance