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 to that activity. The problem is that I get the error: /"Only a single result allowed for a SELECT that is part of an expression"/ Any idea why? And how to solve it? Many thanks. Carlos. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
