On Mar 1, 2009, at 5:18 PM, P Kishor wrote: > It is going to get even more complicated and soon approach Igor-level > of complexity. So, for sanity's sake, it would probably be done better > in your application.
Thanks for the explanation. Yeah, as I said in one of my previous emails, my first inclination was to set this up in a repeat loop in my project with individual calls to SQLite for each "container". I just wanted to make sure there wasn't some more efficient way to do it with a single SQLite call. Turns out there is based on the result Martin came up with, but the complexity... and added complexity you suggest I would run into going forward if I want to do more.... definitely seems to work against any benefit it might have had. So I think, for sanity's sake (er... might already be too late for that :-) I'll take a break, take a couple of aspirin and then I'll go with my first impulse and just chalk this up as a nice diverting (slightly headache inducing) learning experience. -Mike _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
