On Mon, Mar 3, 2008 at 3:09 PM, Jeff Hamilton <[EMAIL PROTECTED]> wrote:
> I have a setup with two databases that have tables which refer to each
> other. I'd like to create triggers to handle cleanup when items are
> deleted from one database that are referred to from the second
> database.
I'm pretty sure this is not allowed, because SQLite can't be sure
you'll have both databases attached with the appropriate logical
names.
What you probably could do would be to write a custom function to
implement the mirroring, and then have the trigger call that. Might
then look like:
CREATE TRIGGER cleanup AFTER DELETE ON data
BEGIN
SELECT temp_db_delete_fn(OLD.id);
END;
-scott
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
