>I am using SELECT SUM on local view. The view is optimistic table buffering. If one record on view is deleted, but tableupdate is not issued, SELECT SUM consider DELETED() record or not?
DELETE, just like other commands that modify data, must be confirmed with TableUpdate(). So, it seems logical that the records will not be considered as deleted in any other place - SELECT-SQL does the equivalent of opening the table AGAIN.
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)