Hello The syntax diagram at the top of https://www.sqlite.org/lang_createtrigger.html implies a SELECT statement can be used between the BEGIN and END key words.
For example - sqlite> CREATE TABLE stuff(thing text); sqlite> CREATE VIEW vstuff as select * from stuff; sqlite> CREATE TRIGGER tstuff instead of insert on vstuff begin insert into stuff select new.thing; select * from stuff; end; sqlite> insert into vstuff select 'object'; -- no output sqlite> select * from stuff; thing object Here we see the INSERT statement was triggered but not the SELECT. Have I misunderstood the syntax diagram? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
