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 wrote: From: Igor Tandetnik Subject: Re: [sqlite] Confitional IF in triggers To: sqlite-users@sqlite.org Received: Sunday, 10 October, 2010, 2:46 AM Russell A wrote: > Hi Igor > I'm converting an Interba

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 > separate SQLite triggers

Re: [sqlite] Confitional IF in triggers

2010-10-08 Thread Russell A
OR'); end; --- On Sat, 9/10/10, Igor Tandetnik wrote: From: Igor Tandetnik Subject: Re: [sqlite] Confitional IF in triggers To: sqlite-users@sqlite.org Received: Saturday, 9 October, 2010, 12:21 AM Russell A wrote: > This may be a really dumb question, but I've searched and can

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 in separate triggers? An

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" To: Sent: Friday, October 08, 2010 01:24 a Subject: [sqlite] Confitional IF in triggers This may be a really dum

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 multiple > conditions m

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