Re: [sqlite] Expression tree is too large

2010-05-05 Thread Andrea Galeazzi
Thanks, it works! Frank Baumgart ha scritto: >> - Ursprüngliche Nachricht - >> Von: Andrea Galeazzi >> Gesendet: 05.05.10 12:14 Uhr >> An: General Discussion of SQLite Database >> Betreff: [sqlite] Expression tree is too large >> >> > Hi g

Re: [sqlite] Expression tree is too large

2010-05-05 Thread Frank Baumgart
> - Ursprüngliche Nachricht - > Von: Andrea Galeazzi > Gesendet: 05.05.10 12:14 Uhr > An: General Discussion of SQLite Database > Betreff: [sqlite] Expression tree is too large > Hi guys, I've got a DELETE statement with a lot of OR: DELETE FROM myTable WHERE id = ? OR

[sqlite] Expression tree is too large

2010-05-05 Thread Andrea Galeazzi
Hi guys, I've got a DELETE statement with a lot of OR: DELETE FROM myTable WHERE id = ? OR id = ?..OR id=? and SQLite throws this error: Expression tree is too large. Do you know a way to avoid such problem or I just have to split the large statement into shorter ones? Cheers