Re: [sqlite] setting a foreign key in a trigger

2008-08-13 Thread Bruce Clift
Thanks for the responses. This sounds like just what I will need. --Bruce ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] setting a foreign key in a trigger

2008-08-11 Thread Bruce Clift
I'm having difficulty writing a trigger in SQLite to do what I need to do. I have very little background in SQL, so I might well be missing something obvious. Any help would be greatly appreciated. I have a table foo with a column that is a foreign key to table bar. Every time a row in foo is