On 10/31/2013 8:22 PM, Igor Korot wrote:
Hi, ALL,
In the CREATE TRIGGER can I use something like this:
CREATE TRIGGER foo AFTER INSERT
BEGIN
IF foo.field1 IS NULL
UPDATE foo SET field1 = <some_value>;
ELSE
UPDATE foo SET field1 = field1 + 1 WHERE field1 > new.<value>;
END;
My concern is if CREATE TRIGER will understand conditionals.
No, there is no IF statement in SQLite. There are other ways to do
operations conditionally. I'd help you with the correct syntax, but I
don't understand what your example is supposed to achieve?
When you say foo.field1, which row of table foo do you want the value to
come from? When you say new.<value>, a value in which field of the newly
inserted row is this supposed to refer to? Perhaps you could explain
what you are trying to do in English, rather than making up some syntax
that doesn't make sense.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users