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
