Re: [sqlite] strange problem with DELETE

2008-02-03 Thread Igor Tandetnik
"RB Smissaert" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Running a query like this: > > delete from sqlite_stat1 > where > not tbl in > ('table1', 'table2', 'table3') > > The strange thing is that rows are deleted where tbl is one of the > listed tables. Look carefully at the

[sqlite] strange problem with DELETE

2008-02-03 Thread RB Smissaert
SQLite 3.5.4, Win XP, VBA with the wrapper dhRichClient Running a query like this: delete from sqlite_stat1 where not tbl in ('table1', 'table2', 'table3') The strange thing is that rows are deleted where tbl is one of the listed tables. Have tried all kind of alterations, such as making it