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
