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
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
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
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
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
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
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.
7 matches
Mail list logo