Apologies for the Spam, and this may be of no importance whatsoever, but
just in case it is useful...
I already mentioned that dropping/messing with the sqlite_stat1 table
doesn't help - BUT it seems if you close the connection and re-open in a
new connection (after you have dropped the sqlite_stat1 table of
course), the Query works again.
Also note: When you leave the stat1 table be, and only close and re-open
the DB (with a new connection instance), the Query still does not work,
so the stat1 table's presence does have an effect.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
