On 11/11/2014 6:15 PM, Ben Newberg wrote:
CREATE TRIGGER t_populate_zweeks
AFTER UPDATE ON zSPs WHEN new.Procedure = 6 AND new.Flag = 1
BEGIN
DELETE FROM zWeeks;
WITH RECURSIVE Weeks(wk) as (select 1 union all select wk + 1 from Weeks
limit 10)
INSERT INTO zWeeks (Week) select wk from Weeks;
END;
When I run this, I get an error message from sqlite3_errmsg() saying syntax
error near "INSERT".
Looks like a bug to me. The statement works standalone, but not within a
trigger.
As a workaround, make it
INSERT INTO zWeeks (Week)
WITH RECURSIVE Weeks(wk) as (select 1 union all select wk + 1 from Weeks
limit 10)
select wk from Weeks;
This works both ways.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
