At 11:26 AM 26/02/2003 +0100, you wrote:

>Hi,
>
>I have got a problem with a parameterized DSQL which
>is supposed to update existing rows in a database.
>
>The DSQL works (or seems to work), it reports no error.
>But when I select the records which were supposed to
>be updated, I see that they are the same as before.
>
>I know this looks like a transaction issue, but the
>transaction encapsulating the DSQL statements *is*
>committed.
>
>I am sure I did some stupid mistake, but I cannot
>find it. I have attached the output of a IB_Monitor.
>
>I am using IBO 4.2 Ib with D6 and Win2K.
>If you need more information, just tell me.

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

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.

Helen