Re: [sqlite] SQlite on delete trigger error

On 19 May 2011 07:16, Support Lists wrote: > Hi, > > I have the following sqlite trigger: > / > /|/CREATE TRIGGER DLT_actymethods_ibfk_1 BEFORE DELETE ON activity FOR > EACH ROW BEGIN DELETE FROM actymethods WHERE ACTY_COD = OLD.ACTY_COD; END/ > > |So before delete the row from the table activity

[sqlite] SQlite on delete trigger error

Hi, I have the following sqlite trigger: / /|/CREATE TRIGGER DLT_actymethods_ibfk_1 BEFORE DELETE ON activity FOR EACH ROW BEGIN DELETE FROM actymethods WHERE ACTY_COD = OLD.ACTY_COD; END/ |So before delete the row from the table activity delete all records from the table actymethods associated