I am more or less playing with triggers trying to learn what they can do. I have a setup where I write data to Table1. An after insert trigger looks up the newly written data codes in Table1, and writes 1 to 4 records to Table2. An after insert trigger on Table2 looks at the new data and updates a handful of other table, creating records if need be.
It all works. It is kind of neat to insert one record, and see changes across a half dozen other tables. But... I want it to do more. The way it is set up, if any of the updates/inserts done by the triggers fail, everything rolls back, including the original data that caused the triggers. What I want to happen is that while everything else gets rolled back, Table1 still has its data, along with the error messages returned by the triggers. Nearest I can tell you can't do that with triggers, but I really don't understand how they work, so maybe I am wrong. So, is there a way to do the following: CREATE TRIGGER table1_insert AFTER INSERT ON TABLE1 BEGIN -- write to other tables (which can fire triggers or return -- constraint failures) -- if writes were not successful (constraint failures, etc.) -- update table1 with message in Errors column -- else -- write 'ok' to Errors column. END; Thanks, David _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
