All, Is it possible to have CTE's within triggers? The way I read the 'SQL As Understood By SQLite', one can, but I could be misinterpreting it.
My DDL for my trigger is as follows: 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". However, when I run the DELETE, WITH and INSERT statements above separately without the Create Trigger DDL, the query runs successfully and populates my zWeeks table with values 1 through 10. Do triggers not support this behavior, or is my syntax incorrect? Thanks, BEN _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
