On 8 Jan 2011, at 6:38am, Nicolas Williams wrote: > Thanks to Drake Wilson and Simon Slavin. The trick was to create a VIEW > that the application uses and which has INSTEAD OF triggers to do the > right thing. This breaks the recursive triggering because there are no > recursive triggers left on the underlying table. Worked like a charm.
No problem. I had forgotten the problem with recursion. I'm glad Drake mentioned it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users