Kurt,

My best idea, Are you shure that the key is unique within the view?

DELETE FROM locks on a per record basis. (IOW it locks the record, performs the delete and so one)
Have you tried to delete the record one by one in browse window?
Have you tried

DELETE FOR isp_deliverynote == '00000055'
TABLEUPDATE(.t.)

?
Does this change something (DELETE FOR locks the table)?

Agnes
>Hi all,
>
>i have a view and when i do "DELETE FROM vwindia_shipment_product WHERE isp_deliverynote == '00000055'" all my records are deleted except one although this record also match the criteria. When i do the delete again only then is this record deleted. I've check if there is a lock on the record the first time but there isn't any.
>
>Somebody has a clue why this record isn't deleted ?
>
>thnx
>
>Kurt