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

[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 
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

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

[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 return no data.

It should be possible to find out if the SELECT is being processed by defining 
an external function which includes a log statement.  But this information is 
probably useless to you.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users