Re: [sqlite] SQLITE_MAX_EXPR_DEPTH

Hi, Is there any limitation on the number of elements in IN clause ? Thanks. Felix Radensky Embedded Solutions Ltd. drh-2 wrote: > > Jerry Krinock <[EMAIL PROTECTED]> wrote: >> My query: >> >> DELETE FROM `table1` WHERE (`id`=1 OR `id`=2 OR `id`=3 OR ... OR `id`=N) >> >> using the C API.

Re: [sqlite] SQLITE_MAX_EXPR_DEPTH

On 2008 Jan, 18, at 19:34, [EMAIL PROTECTED] wrote: But instead of all that trouble, why not just say: id IN (1,2,3,4,5,...,N) Well, I guess the reason I did not say that is because: I had not yet had my SQL lesson for the day. All is wonderful now. Thank you for this, and the explanat

Re: [sqlite] SQLITE_MAX_EXPR_DEPTH

Jerry Krinock <[EMAIL PROTECTED]> wrote: > 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.o

[sqlite] SQLITE_MAX_EXPR_DEPTH

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