Database clear each time my application runs

Question

Does anyone know how to reset the database everytime my application executes in real device ?

I currently have this code but it does not work...

public void doDBCheck()
    {
        try{
                File file = new File(context.getExternalFilesDir(null).getAbsolutePath());
                file.delete();
        }catch(Exception ex)
        {
            }
        }

Any solutions ?

http://stackoverflow.com/questions/4406067/how-to-delete-sqlite-database-from-android-programmatically — jmj, Jul 21 '13 at 22:55
You'd write that snippet of code where you actually want to delete the database. — W.K.S, Jul 21 '13 at 23:03
When you say reset the db do you mean Delete the database file itself OR clear the database of all records? — W.K.S, Jul 21 '13 at 23:04
clear the database of all records... I'll put in on my onCreate() in MainActivity — edmund02, Jul 21 '13 at 23:05
Then you want a different answer. Wait let me write it for you. — W.K.S, Jul 21 '13 at 23:05
Did you try this: [How to Delete All Items From SQLite in Android](http://stackoverflow.com/a/5683940/2558882). — Vikram, Jul 21 '13 at 23:07

score 0 · Answer 1 · answered Jul 21 '13 at 23:09

0

public void clearDatabase()
{
SQLiteDatabase db = helper.getWritableDatabase();
db.delete({tablename},null,null) // write this line for each table in your db.
}

answered Jul 21 '13 at 23:09

W.K.S

9,787
15
75
122

Database clear each time my application runs

1 Answers1