Re: [sqlite] [EXTERNAL] Trigger Question

2017-10-13 Thread Stephen Chrzanowski
deleting priority 0 colors'); > end; > > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Hick Gunter > Sent: Thursday, October 12, 2017 3:01 AM > To: 'SQLite mailing list' > Subject: Re: [sqlite] [E

Re: [sqlite] [EXTERNAL] Trigger Question

2017-10-12 Thread David Raymond
: Thursday, October 12, 2017 3:01 AM To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL] Trigger Question INSTEAD OF triggers are only allowed on views. From the documentation I would suggest using a BEFORE trigger and calling RAISE() in the trigger program. I expect RAISE(IGNORE) to silently

Re: [sqlite] [EXTERNAL] Trigger Question

2017-10-12 Thread Hick Gunter
INSTEAD OF triggers are only allowed on views. From the documentation I would suggest using a BEFORE trigger and calling RAISE() in the trigger program. I expect RAISE(IGNORE) to silently abort the calling statement. -Ursprüngliche Nachricht- Von: sqlite-users