When you extend SQLiteOpenHelper, override this method: public void onUpgrade(final SQLiteDatabase db, final int oldVersion, final int newVersion)
It will be called when your application is being updated with a newer version. On Jan 5, 8:52 am, "Dan Dumont" <ddum...@gmail.com> wrote: > There is a method that will get called when the version number you supply to > the create db command exceeds the listed version that the user has ( you've > upgraded your design ) > > You then put code in that handler to handle the database schema updates. > Sorry I can't be more specific... my code is at home. > > On Mon, Jan 5, 2009 at 3:34 AM, Jean-Baptiste Queru <j...@google.com> wrote: > > > You might find SQLiteOpenHelper useful to manage the various scenarios. > > > JBQ > > > On 1/5/09, Jay-andro <jayan...@gmail.com> wrote: > > > > I have an app that creates an sqllite database on first-use, if one > > > doesn't already exist. Recently I released a new version of the app, > > > and all of a sudden several users are complaining of erros that I > > > didnt encounter in my testing. In my development I always installed > > > using adb over usb, which in turn requires uninstall the older version > > > first. So the database was always created anew on first-use of the new > > > version. But I suspect my existing users are doing an in-place install > > > on top of their old version, in which case the old db is incompatible > > > with the new one. > > > > So my questions are: > > > - Does the Market app allow you to install a new version "on top of" > > > an old one, without requiring an uninstall first (unlike adb)? > > > - If an in-place upgrade is supported but the database is not dropped, > > > the question arises what else is not deleted? Resources, preferences, > > > manifest? I suspect there would be major havoc if these things werent > > > completely removed & replaced by the new version. > > > > I am now contemplating adding a preference which will indicate to the > > > app what version of my db it needs and use this on first-use to > > > determine if I need to drop and recreate the database or just use the > > > old db. > > > > Any thoughts? > > > -- > > Jean-Baptiste M. "JBQ" Queru > > Android Engineer, Google. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---