HI

I have DeleteSQL of

DELETE FROM SHIPMENTS WHERE
REC = ? /* OLD_REC */ and
not exists(select * from shipping_line where shipment=? /* OLD_REC */ )

but only the first occurrence of old_rec gets set

EXECUTE STATEMENT
TR_HANDLE = 24342488
STMT_HANDLE = 37637208
PARAMS = [ Version 1 SQLd 2 SQLn 2
[OLD_REC] = 4176429
[OLD_REC] = <NULL> ]

Any reason why both shouldn't get set?

Regards
Paul


[Non-text portions of this message have been removed]