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. Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
