Sorry for the delay, Paul....was travelling.

Do you do a tableupdate before requerying? If you requery, you'll lose any uncommitted changes. I'm a bit unclear as to the order of steps you are taking when you delete. Could you post that order here?


>
>Thanks for responding....
>
>I tried refreshing the grid after the delete and this doesn't work the record still appears in the grid...I tried doing a browse on the view and it does show deleted but it still shows in the grid. Set deleted is on.
>
>Anyway, to get the record to not show in the grid I do a requery on the view and make sure the the table the view is based on is not in the data environment. If the table is in the data environment the requery does not make the deleted record disappear.
>
>I wonder if this requery is causing the the deletion to be committed to the base table.
>
>I hope this makes sense....I can't find a solution to this problem.
>
>
>>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