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 case-insensitive, leaving off single quotes or doing instead double-quotes, but I always get deletes that should not happen. Must be overlooking something simple here, but can't see it and thanks for any advice. RBS _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users