Re: [sqlite] Confitional IF in triggers

2010-10-09 Thread Russell A
Thanks Igor - that's very helpful. --- On Sun, 10/10/10, Igor Tandetnik <itandet...@mvps.org> wrote: From: Igor Tandetnik <itandet...@mvps.org> Subject: Re: [sqlite] Confitional IF in triggers To: sqlite-users@sqlite.org Received: Sunday, 10 October, 2010, 2:46 AM Russ

Re: [sqlite] Confitional IF in triggers

2010-10-09 Thread Igor Tandetnik
Russell A wrote: > Hi Igor > I'm converting an Interbase DB for use in a smaller application, so there are > many different examples. > > I've included one particular example below, where I have converted a single > Interbase trigger (which used IF statements), into 4 >

Re: [sqlite] Confitional IF in triggers

2010-10-08 Thread Russell A
detnik <itandet...@mvps.org> Subject: Re: [sqlite] Confitional IF in triggers To: sqlite-users@sqlite.org Received: Saturday, 9 October, 2010, 12:21 AM Russell A <slurc...@yahoo.com.au> wrote: > This may be a really dumb question, but I've searched and can't find an > answ

Re: [sqlite] Confitional IF in triggers

2010-10-08 Thread Igor Tandetnik
Russell A wrote: > This may be a really dumb question, but I've searched and can't find an > answer. > Do SQLite triggers support any conditional expressions, like IF, or is there > only the WHEN statement? If the latter, does that > mean that multiple conditions must be

Re: [sqlite] Confitional IF in triggers

2010-10-08 Thread Brian P Curley
On a field by field basis: CASE..WHEN [condition 1]..THEN [result 1]..WHEN [condition n]..THEN [result n]..ELSE..END - Original Message - From: "Russell A" <slurc...@yahoo.com.au> To: <sqlite-users@sqlite.org> Sent: Friday, October 08, 2010 01:24 a Subject

Re: [sqlite] Confitional IF in triggers

2010-10-07 Thread Drake Wilson
Quoth Russell A , on 2010-10-07 22:24:23 -0700: > This may be a really dumb question, but I've searched and can't find an > answer. > Do SQLite triggers support any conditional expressions, like IF, or is there > only the WHEN statement? If the latter, does that mean that

[sqlite] Confitional IF in triggers

2010-10-07 Thread Russell A
This may be a really dumb question, but I've searched and can't find an answer. Do SQLite triggers support any conditional expressions, like IF, or is there only the WHEN statement? If the latter, does that mean that multiple conditions must be in separate triggers? Any help appreciated.Stopgap.