Hi Helen,

> Does the DSQL execute in the same transaction as the SELECT statement?

No. The select is done by another program after the updating program
has terminated.

> I can't actually see anything in your monitor output that
> indicates you are
> re-running your select inside *this* transaction (or any
> transaction). I
> see you are using CommitRetaining, which does not make sense for a
> transaction which only performs DML.
> If you are using CommitRetaining and not ReadCommitted in the
> transaction
> where the SELECT occurs, you won't see committed work until
> you do a hard
> commit there.

You are right concerning CommitRetaining. I had accidentally
set AutoCommit = True for my Transaction.

But anyway, it should work because there *is* a hard commit at
the end of the update (take a look at the end of the IB_Monitor
output of my first mail).


Christian



PS: I have set AutoCommit to False so that there are no
'CommitRetainings', but it still does not work.