That's there for use of the raise() function. For example... create trigger tbl_stop_deletes before delete on tbl begin select raise(abort, 'Not allowing Delete''s from this table'); end;
-----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Shane Dev Sent: Thursday, December 21, 2017 10:12 AM To: SQLite mailing list Subject: [sqlite] Can a SELECT statement be used within a trigger? 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
