Thanks for reply Flying Coder your approach looks smart, How it will be for remote update, will it give proper results for apps version up-gradation remotely.
Thank you. On Nov 16, 12:57 pm, Flying Coder <[email protected]> wrote: > Override the onUpdate method of SQLiteOpenHelper and do: > > if (oldVersion < VERSION_WHEN_COLUMN_ADDED) > db.execSQL("alter table " + TABLE_NAME + " add column " + > COLUMN_NAME + " " + COLUMN_TYPE + ";"); > > Cheers, > Steve > > On Nov 16, 8:17 am, "jagtap.jj" <[email protected]> wrote: > > > Hello everybody > > > Is there way for Android or in SQLite to preserve old version Db table > > columns, while adding new table columns for new version. > > > The new application version should not vanish all user data from old > > version. > > > Any suggestions? -- 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
