>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

SELECT - SQL opens the FROM tables separatelt, whether they are open already or not. It's the same as another user on the network trying to access the data in the buffers.

- Keith