I would like to force the delete detail records before delete master records.

What is the best way to do it. I tried use on before delete trigger something like this

EXECUTE IMMEDIATE 'DELETE FROM DetailTableName WHERE xMasterGUID=''+OLDROW.xGUID+'''

not working

Thanks,

Jianfei

Jianfei


I use the after delete trigger with the same code as you and it works fine. Try switching from before delete to after delete. I'd always prefer to use after delete just in case it doesn't delete after all.

Roy Lambert

Jianfei,

<< What is the best way to do it. I tried use on before delete trigger
something like this >>

What are you seeing - an error message or does it simply not work ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Just Do nothing.

I am using following Code, it works


CREATE TRIGGER DD_xDP_ProgressActivity AFTER DELETE ON xDP_ProgressActivity
BEGIN
DECLARE DD STATEMENT;
PREPARE DD FROM 'DELETE FROM xDP_ProgressActivity_File WHERE xFileGUID=?';
EXECUTE DD USING OLDROW.xGUID;
END

Thanks,