Re: [sqlite] Before Update trigger question

On Tue, 2 Jun 2009 12:28:31 -0700 (PDT), Boris Ioffe wrote: > > Kees, > Thank you very much for quick prototype. I will use single > quotes from now on. It turns out Igor was right. > I had another trigger. Yes, always read Igor's replies first ;) Triggers are very powerful, yet tricky. Neve

Re: [sqlite] Before Update trigger question

Thanks for asking your crystal ball. it works rather well. --- On Tue, 6/2/09, Igor Tandetnik wrote: > From: Igor Tandetnik > Subject: Re: [sqlite] Before Update trigger question > To: sqlite-users@sqlite.org > Date: Tuesday, June 2, 2009, 2:48 PM > Boris Ioffe > wrote: &

Re: [sqlite] Before Update trigger question

09, Kees Nuyt wrote: > From: Kees Nuyt > Subject: Re: [sqlite] Before Update trigger question > To: sqlite-users@sqlite.org > Date: Tuesday, June 2, 2009, 2:35 PM > On Tue, 2 Jun 2009 09:38:18 -0700 > (PDT), Boris Ioffe > > wrote: > > > > >Hello Gang, >

Re: [sqlite] Before Update trigger question

Boris Ioffe wrote: > --- On Tue, 6/2/09, Igor Tandetnik > wrote: > >> From: Igor Tandetnik >> Subject: Re: [sqlite] Before Update trigger question >> To: sqlite-users@sqlite.org >> Date: Tuesday, June 2, 2009, 2:11 PM >> Boris Ioffe >> wrote: >&

Re: [sqlite] Before Update trigger question

gor Tandetnik > Subject: Re: [sqlite] Before Update trigger question > To: sqlite-users@sqlite.org > Date: Tuesday, June 2, 2009, 2:11 PM > Boris Ioffe > wrote: > > This is my first question on this mail list. I noticed > that BEFORE > > UPDATE trigger goes off even for i

Re: [sqlite] Before Update trigger question

On Tue, 2 Jun 2009 09:38:18 -0700 (PDT), Boris Ioffe wrote: > >Hello Gang, >This is my first question on this mail list. I noticed that BEFORE UPDATE >trigger goes off even for insert statements. > >My example: >CREATE TRIGGER validate_players_update BEFORE UPDATE ON players >WHEN (ne

Re: [sqlite] Before Update trigger question

Boris Ioffe wrote: > This is my first question on this mail list. I noticed that BEFORE > UPDATE trigger goes off even for insert statements. My crystal ball shows you have an INSERT trigger that performs an UPDATE. Igor Tandetnik ___ sqlite-users

[sqlite] Before Update trigger question

Hello Gang, This is my first question on this mail list. I noticed that BEFORE UPDATE trigger goes off even for insert statements. My example: CREATE TRIGGER validate_players_update BEFORE UPDATE ON players WHEN (new.role in (1,2) and (select count(*) from players where ta