On 16 Nov 2010, at 10:18pm, Bernard Ertl wrote: > Kees Nuyt wrote: >> > >>> Nicolas Williams-2 wrote: >>>> Do you have recursive triggers enabled? >>> >>> I'm not sure. How do I check? >> >> http://www.sqlite.org/pragma.html#pragma_recursive_triggers > > I'm not using any pragma commands, so no, I'm not using recursive triggers.
In that case, although you can define a trigger that would trigger itself, SQLite will silently drop all such situations: the trigger will be fired once, but attempts to fire itself will be ignored. You can use that PRAGMA to change this behaviour. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users