INSERT and INSTEAD OF INSERT triggers have no result set. The select will be performed, but it's result set is discarded. Same for UPDATE and INSTEAD OF UPDATE triggers.
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Shane Dev Gesendet: Donnerstag, 21. Dezember 2017 16:12 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: [EXTERNAL] [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; CREATE TRIGGER tstuff sqlite> 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 ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
