It looks like you are confusing records, tables and databases. Can you post some more code, like how you create the database, how you create the table in the database, and how you store and retrieve records in the table?
On Fri, Apr 17, 2009 at 5:27 AM, Zhubham <[email protected]> wrote: > > Hi, > > In my application i take some input from the user and store it in > sqlite database. Now, if on second visit to save records menu, I give > the previous file name then the database holding above file should be > dropped and a new database should be made. > > I do this by : > > public void deleteRecord() > { > try > { > db.execSQL("DROP TABLE IF EXISTS " +DATABASE_TABLE); > db.execSQL("VACUUM"); > } > catch(SQLException sqle) > { > sqle.printStackTrace(); > } > > } > > However, on doing this the previous records are not getting deleted. > With this the new records get appended to the previous ones. > > Can anyone please help me with this?? > > Thanks in advance. > > Best Regards, > Zhubham > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
