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

Re: [sqlite] Before Update trigger question

Thanks for asking your crystal ball. it works rather well. --- On Tue, 6/2/09, Igor Tandetnik <itandet...@mvps.org> wrote: > From: Igor Tandetnik <itandet...@mvps.org> > Subject: Re: [sqlite] Before Update trigger question > To: sqlite-users@sqlite.org > Date: Tuesda

Re: [sqlite] Before Update trigger question

k.n...@zonnet.nl> wrote: > From: Kees Nuyt <k.n...@zonnet.nl> > 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 > <bioff...@yaho

Re: [sqlite] Before Update trigger question

Boris Ioffe <bioff...@yahoo.com> wrote: > --- On Tue, 6/2/09, Igor Tandetnik > <itandet...@mvps.org> wrote: > >> From: Igor Tandetnik <itandet...@mvps.org> >> Subject: Re: [sqlite] Before Update trigger question >> To: sqlite-users@sqlite.org >>

Re: [sqlite] Before Update trigger question

org> wrote: > From: Igor Tandetnik <itandet...@mvps.org> > Subject: Re: [sqlite] Before Update trigger question > To: sqlite-users@sqlite.org > Date: Tuesday, June 2, 2009, 2:11 PM > Boris Ioffe <bioff...@yahoo.com> > wrote: > > This is my first question

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

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