Thanks Simon. The 10 is just an arbitrary value I chose for this example. The user actually determines the value at run-time, so this value could be any integer. I have a way to settle that, if only I could figure out how I can get this trigger working.
BEN On Tue, Nov 11, 2014 at 5:41 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 11 Nov 2014, at 11:15pm, Ben Newberg <ben.newb...@gmail.com> wrote: > > > WITH RECURSIVE Weeks(wk) as (select 1 union all select wk + 1 from Weeks > > limit 10) > > INSERT INTO zWeeks (Week) select wk from Weeks; > > Just use 10 INSERT commands. > > I don't know what's causing your error message, but your code will be > simpler if you just don't use RECURSIVE unnecessarily. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users