Re: [sqlite] Can a SELECT statement be used within a trigger?

2017-12-21 Thread David Raymond
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

Re: [sqlite] Can a SELECT statement be used within a trigger?

2017-12-21 Thread Simon Slavin
On 21 Dec 2017, at 3:11pm, Shane Dev wrote: > Here we see the INSERT statement was triggered but not the SELECT. Have I > misunderstood the syntax diagram? It’s possible that the SELECT is being processed. However, since the INSERT command returns no data it still can