Another thing I noticed related to buffering is that a SEEK for a record which has been added but not committed will return TRUE...however, a SQL - SELECT for the same condition will not return any records.

Can someone explain the reasoning behind this so I can better understand why\when to use buffering? I'm trying to eliminate using memory variables or copying records when there's a possibility of reverting changes, but need to do calculations utilizing SQL statements on uncommitted data as well.

Thanks - Victor