My query: DELETE FROM `table1` WHERE (`id`=1 OR `id`=2 OR `id`=3 OR ... OR `id`=N)
using the C API. When N exceeds 999, I get an error stating that the maximum depth of 1000 has been exceeded, and this is documented in http://www.sqlite.org/limits.html , item 5.
Of course, I could fix this by doing multiple queries when N>999, but my code is very nicely encapsulated as is, and that change would make it all yucky. So I'd like other alternatives.
1. I would describe my query as "1000 clauses wide". I'm not nesting anything "1000 levels deep". Is there a way to rewrite my query and make it work?
2. Documentation implies that I can change the parameter SQLITE_MAX_EXPR_DEPTH from the default of 1000. But I can't find SQLITE_MAX_EXPR_DEPTH in sqlite3.h. Seems to be neither a compiler macro nor a global. (Mac OS X 10.5, sqlite 3.4.0). Where is it?
Thanks, Jerry Krinock ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
