Hi Igor, Thank you for the qick response. Of course, this PRAGMA solved the entire issue, once I got a never version of SQLite installed.
Thank you! /Fredrik On Tue, Nov 16, 2010 at 10:58 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Fredrik Karlsson <dargo...@gmail.com> wrote: >> I'm probably doing something really stupid here, but I feel I need to >> ask you anyway to see id there is something that I've missed. >> Is it not possible for a trigger to trigger itself? > > Recursive triggers have to be explicitly turned on: > > http://sqlite.org/pragma.html#pragma_recursive_triggers > >> Second question is, of course, can I depend on this behaviour? Or, is >> it just because of the version of SQLite I am currently using >> (3.6.16)? > > Recursive triggers are supported beginning with 3.6.18. > -- > Igor Tandetnik > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- "Life is like a trumpet - if you don't put anything into it, you don't get anything out of it." _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users