Subject Re: [IBO] DSQL changes are not inserted into the DB
Author Svein Erling Tysvaer
What are the RowsAffected by your DSQL statement?

Set

At 11:26 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.
>
>Thanks in advance for your help.
>
>
>Christian
>UPDATE T_Projekte SET Geloescht = 'J' WHERE ProJobnr = ? /* PP */
>[26.02.2003-11:09:25/JB]: Lösche Datensatz: '-00001'