sqlite with android no such table
<p>I have been testing my app which uses the dbadapter from Reto Meir's earthquake example.  Everything was going ok for several days but when debugging with the app on the device today I got the 'no such table' error.  I changed the name of the database and all runs well again.  This doesn't give me much confidence regarding potential other users.</p>

<p>Since it seems impossible to see the database on the phone, by design I suppose, I can't see how to find out what caused the problem and take steps to avoid it.   The database appears to open ok at the start of the program but errors when handling a select query.   Just changing the name of the table doesn't fix it, it has to be a new database name.</p>

<p>As the change of name allows it to run ok I can't see that the code is wrong.  I wonder if the data becomes corrupted.</p>

<p>I've also found that after successfully inserting  a row, then later getting a cursor to allitems sometimes produces a -1 error against a get for one of the column names.   How can a column name drop out of the columns index?</p>

<p>I've googled this type of problem and whilst there are a lot of folks with the problem and a lot of replies I can't find anything which informs on the underlying reason for these problems - which is what I am after. </p>
