Hi Paul,
Problem one: If the view is not table buffered, then the reason tablerevert doesn't work could be that the delete was committed by a record pointer change.
Problem two: Are you refreshing the grid after the delete?
>If I delete a record in a buffered updateable view and then do a tablerevert on the view the record in the base table doesn't get reverted...in other words it is still deleted. Why is this? Am I doing something wrong? Also If I delete a record in a view the record is still displayed in my grid even though I have set deleted on. How can I get the record in the view to not show after it is deleted?
>
>TIA
>Paul Acton
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05