>I think I worked it out yesterday.
>
>I was using a DO WHILE loop around the view and doing a TABLEUPDATE(0, .T.) on each record. Of course if SET DELETED was OFF then the deleted rows would get deleted properly, but if it was ON, then they would get skipped by the DO WHIE and so never get updated!
Perhaps then, you should rather use GetNextModified() to select, one by one, the modified records. I suspect this will include the deleted records, but you will have to test it.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)