Hi: I want to use to trigger on deletion of a detail record to automatically delete a summary record, if not more detail records exist, something like:
CREATE TRIGGER detail_delete AFTER DELETE ON detail BEGIN -- here I don't know syntax IF COUNT(detail records with key) = 0 DELETE summary WHERE key=old.key; END; Is something like this possible to do? Any suggestions. Thanks in advance _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users