Hi Martijn,

here is my loop:

FOR SELECT PK, FK_PROD
FROM PRODUCT_TREE
WHERE FK_PARENT = :THIS_PK_TREE AND FK_PROD IS NOT NULL
INTO :PK_TREE_PROD, :PK_PROD
DO
BEGIN

-- delete the record in the product tree
DELETE FROM PRODUCT_TREE WHERE PK = :PK_TREE_PROD;

-- SNIP ---

END

> That's how it is.
>
> You probably have done something wrong in your code --
>
> 1) how are you checking that the body is being processed?

I'm using the debugger of EMS IBManager. There I can see
that the line DELETE FROM... is processed, although there
are no matching records....

> 2) care to show some code?

see above