I have dropped the double index DROP INDEX 'InternalName'; Then executed the SQL Select statement which caused the sqlite warning. But same warning, nothing changed.
Then I added a new index CREATE INDEX idx_installid ON ... Now the sqlite warning is gone away. :-) The SQL statement has a JOIN like; .. LEFT JOIN is_mytable H ON H.InstallD = I.InstallD perhaps this was the problem? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users