In my case I read the restriction of the triggers: I use database.table and I insert with default values.
I can't use triggers for this. /Patrik On 02/19/2013 04:27 PM, Dave McKee wrote: >> Is it possible to use triggers for this? > > Yes. > > "Triggers may be created on views, as well as ordinary tables, by > specifying INSTEAD OF in the CREATE TRIGGER statement. If one or more ON > INSERT, ON DELETE or ON UPDATE triggers are defined on a view, then it is > not an error to execute an INSERT, DELETE or UPDATE statement on the view, > respectively. Instead, executing an INSERT, DELETE or UPDATE on the view > causes the associated triggers to fire. The real tables underlying the view > are not modified (except possibly explicitly, by a trigger program)." > > http://www.sqlite.org/lang_createtrigger.html > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
