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

-----------------------------------------------
/*---
PREPARE STATEMENT
TR_HANDLE = 3302500
STMT_HANDLE = 3296856

UPDATE T_Projekte SET Geloescht = 'J' WHERE ProJobnr = ? /* PP */

PLAN (T_PROJEKTE INDEX (RDB$17))

FIELDS = [ Version 1 SQLd 0 SQLn 30 ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 3302500
STMT_HANDLE = 3296856
PARAMS = [ Version 1 SQLd 1 SQLn 1
[PP] = ''POW-00033'' ]

SECONDS = 0,010
----*/
/*---
COMMIT RETAINING
TR_HANDLE = 3302500
----*/
[26.02.2003-11:09:25/JB]: Lösche Datensatz: '-00001'
/*---
EXECUTE STATEMENT
TR_HANDLE = 3302500
STMT_HANDLE = 3296856
PARAMS = [ Version 1 SQLd 1 SQLn 1
[PP] = ''-00001'' ]
----*/
/*---
COMMIT RETAINING
TR_HANDLE = 3302500
/*---
COMMIT
TR_HANDLE = 3302500
----*/
/*---
DISCONNECT DATABASE
DB_HANDLE = 3292184
----*/