>
> True for REPEATABLE READ and SNAPSHOT TABLE STABILITY isolation levels,
> not true for READ COMMITTED. A RC transaction sees everything that is
> committed in the database, at all times. Perhaps you are confusing
> this with what *the application* sees in its client-side
> buffers....your Delphi datasets, for example, will continue to display
> what was stored in their buffers until you requery.
>

I say again:

> Is it possible for my RO/RC transaction to see one of the two rows
> affected by the intervening UPDATE in its state *****before the

intervening

> COMMIT****, and the other in its state after that COMMIT?

My answer is no and you agree with me (above) - An RC transaction sees what
is committed.
He's asking if you see it BEFORE the commit.

So a select statement will NOT see something which is NOT committed.
Alan