>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?

for this uses:

SELECT ... FROM alias WITH (BUFFERING = .T.) ...