Hi I have a desktop app that loads an SQLite database into a datagrid.
Before loading data, it goes through series of checks to make sure that the user's database has the correct indexes set up. The very last check is to test for the existence of the index I originally used on the database a while back, and if there, drop it, using "DROP INDEX IF EXISTS index1" - Once dropped, the index should NEVER have to be dropped again, as it's not there, right? The process works fine at first - first time around, the index is dropped (this takes about 20 seconds on my test database). On subsequent loads, no dropping occurs. However, if you restart your computer, the dropping process occurs again the first time the app loads the database!!! I tested for the existence of the index by restarting, and loading the database in SQLite Administrator, and it's definitely NOT there. Any idea what could be causing this? Thanks for taking a look. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
