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.
Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
