>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?
If you delete a record in a view, do a TABLEUPDATE() (or move the pointer if the view is record buffered), then the deletion is written to the table. Doing a TABLEREVERT() does nothing after the changes are written.
?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?
You have to move the record pointer off of the deleted record, and it will disappear from the grid.
Erik Moore
Clientelligence