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 <[email protected]> wrote: > > On 11 Nov 2014, at 11:15pm, Ben Newberg <[email protected]> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
