2014/10/16 上午 08:12:12

android Programming Glossary: dbhelper

http://stackoverflow.com/questions/12015731/android-sqlite-example

class as below public class MyDB private MyDatabaseHelper dbHelper private SQLiteDatabase database public final static String EMP_TABLE.. of employee @param context public MyDB Context context dbHelper new DatabaseHelper context database dbHelper.getWritableDatabase.. context dbHelper new DatabaseHelper context database dbHelper.getWritableDatabase public long createRecords String id String..

Delete row in database table given one column value - which is a string

http://stackoverflow.com/questions/3314176/delete-row-in-database-table-given-one-column-value-which-is-a-string

the row in the table that has Name myName. In onCreate dbHelper new DBAdapter this dbHelper.open Function in DBAdapter class.. has Name myName. In onCreate dbHelper new DBAdapter this dbHelper.open Function in DBAdapter class public boolean deleteTitleGivenName.. public boolean deleteTitleGivenName String myName return dbHelper.delete DATABASE_TABLE_2 KEY_NAME myName null 0 Function call..

Is it possible to move the internal DB to the SDCard?

http://stackoverflow.com/questions/3436434/is-it-possible-to-move-the-internal-db-to-the-sdcard

to access the database.... private static DBUtil dbHelper null public void openDatabase if dbHelper null dbHelper new.. static DBUtil dbHelper null public void openDatabase if dbHelper null dbHelper new DBUtil this.context dbHelper.openDataBase.. dbHelper null public void openDatabase if dbHelper null dbHelper new DBUtil this.context dbHelper.openDataBase SQLiteDatabase.OPEN_READWRITE..

I'm getting a Database Object Not Closed Exception in SQLite (Android), but I'm explicitly closing my database… Help?

http://stackoverflow.com/questions/4940308/im-getting-a-database-object-not-closed-exception-in-sqlite-android-but-im

i String userCheck jObj.getString username TagDBAdapter dbHelper new TagDBAdapter context dbHelper.open OPENING THE DATABASE.. username TagDBAdapter dbHelper new TagDBAdapter context dbHelper.open OPENING THE DATABASE Contact contact new Contact String.. contact.setWorkPhone jObj.getString workphone if dbHelper.checkForExisting userCheck true dbHelper.createContact contact..

How to initialize sqlite database once from a helper class in Android

http://stackoverflow.com/questions/7444327/how-to-initialize-sqlite-database-once-from-a-helper-class-in-android

something that I was trying to do DataBaseHelper dbHelper some code dbHelper new DataBaseHelper context ops_sys_tpl.sqlite.. that I was trying to do DataBaseHelper dbHelper some code dbHelper new DataBaseHelper context ops_sys_tpl.sqlite null 1 DataBaseHelper.initialize.. 1 DataBaseHelper.initialize context stampii_sys_tpl.sqlite dbHelper.copyDataBase ops_sys_tpl.sqlite dbHelper.getDatabase dbHelper.executeQuery..

Android: Overlay on Android Camera Preview

http://stackoverflow.com/questions/7466336/android-overlay-on-android-camera-preview

imagepath public static int x 1 private RdmsDbAdapter dbHelper @Override protected void onCreate Bundle savedInstanceState.. true DBAdapter instance created and connection opened. dbHelper new RdmsDbAdapter CameraActivity.this dbHelper.open setting.. opened. dbHelper new RdmsDbAdapter CameraActivity.this dbHelper.open setting up flags NewIncidentHelper nih new NewIncidentHelper..

keeping a variable value across all android activities

http://stackoverflow.com/questions/8573796/keeping-a-variable-value-across-all-android-activities

extends ListActivity private OverLimitDbAdapter dbHelper private Cursor cursor Called when the activity is first created... setContentView R.layout.main this.getListView dbHelper new OverLimitDbAdapter this dbHelper.open fillData registerForContextMenu.. this.getListView dbHelper new OverLimitDbAdapter this dbHelper.open fillData registerForContextMenu getListView @Override protected..

Easy database access methods in Android

http://stackoverflow.com/questions/17234451/easy-database-access-methods-in-android

email text not null final Context context DatabaseHelper DBHelper SQLiteDatabase db public DBAdapter Context ctx this.context.. db public DBAdapter Context ctx this.context ctx DBHelper new DatabaseHelper context private static class DatabaseHelper.. the database public DBAdapter open throws SQLException db DBHelper.getWritableDatabase return this closes the database public void..

Getting stored data from database into ListView.

http://stackoverflow.com/questions/3090041/getting-stored-data-from-database-into-listview

null private final Context context private DatabaseHelper DBHelper private SQLiteDatabase db public DBAdapter Context ctx this.context.. db public DBAdapter Context ctx this.context ctx DBHelper new DatabaseHelper context private static class DatabaseHelper.. the database public DBAdapter open throws SQLException db DBHelper.getWritableDatabase return this closes the database public void..

column _id does not exist

http://stackoverflow.com/questions/3360605/column-id-does-not-exist

Multiple Table SQLite DB Adapter(s) in Android?

http://stackoverflow.com/questions/4063510/multiple-table-sqlite-db-adapters-in-android

NLS 2 private final Context context private DatabaseHelper DBHelper private SQLiteDatabase db Constructor @param ctx public DBAdapter.. ctx public DBAdapter Context ctx this.context ctx this.DBHelper new DatabaseHelper this.context private static class DatabaseHelper.. public DBAdapter open throws SQLException this.db this.DBHelper.getWritableDatabase return this close the db return type void..

how can i get the repeat alarm for week days using alarm manager in android?

http://stackoverflow.com/questions/7357469/how-can-i-get-the-repeat-alarm-for-week-days-using-alarm-manager-in-android

public void onReceive Context context Intent intent DBHelper mDbh new DBHelper context null null 1 mDb mDbh.getWritableDatabase.. onReceive Context context Intent intent DBHelper mDbh new DBHelper context null null 1 mDb mDbh.getWritableDatabase mDb.setLockingEnabled..

How to initialize sqlite database once from a helper class in Android

http://stackoverflow.com/questions/7444327/how-to-initialize-sqlite-database-once-from-a-helper-class-in-android

class MyTestDatabaseInstanceHolder public MyTestDBHandler DBHelper public static SQLiteDatabase m_ObjDataBase This is global variable.. public static void createDBInstance Context pContext if DBHelper null DBHelper new WLDBHandler pContext This will be your DB.. void createDBInstance Context pContext if DBHelper null DBHelper new WLDBHandler pContext This will be your DB Handler Class..

How to create a Table with a column of type BLOB in a DBAdapter

http://stackoverflow.com/questions/7516933/how-to-create-a-table-with-a-column-of-type-blob-in-a-dbadapter

private final Context context private DatabaseHelper DBHelper private SQLiteDatabase db Constructor @param ctx public DBAdapter.. DBAdapter public DBAdapter open throws SQLException this.DBHelper new DatabaseHelper this.context this.db this.DBHelper.getWritableDatabase.. this.DBHelper new DatabaseHelper this.context this.db this.DBHelper.getWritableDatabase return this close the db return type void..

how to display SQLite DataBase table?

http://stackoverflow.com/questions/7553203/how-to-display-sqlite-database-table

null private final Context context private DatabaseHelper DBHelper private SQLiteDatabase db public DBAdapter3x3 Context ctx this.context.. db public DBAdapter3x3 Context ctx this.context ctx DBHelper new DatabaseHelper context private static class DatabaseHelper.. database public DBAdapter3x3 open throws SQLException db DBHelper.getWritableDatabase return this closes the database public void..

Is it possible to apply primary key on the text fields in android database

http://stackoverflow.com/questions/7591492/is-it-possible-to-apply-primary-key-on-the-text-fields-in-android-database

How to check if a value already exists in the database in Android

http://stackoverflow.com/questions/7820905/how-to-check-if-a-value-already-exists-in-the-database-in-android

final Context context private static DatabaseHelper DBHelper private static SQLiteDatabase db private static String TAG ##.. SecondActivityUserHelper Context ctx this.context ctx DBHelper new DatabaseHelper context private static class DatabaseHelper..

Deleting Row in SQLite in Android

http://stackoverflow.com/questions/7510219/deleting-row-in-sqlite-in-android

private static final int DATABASE_VERSION 1 private DbHelper helper private final Context context private SQLiteDatabase.. this.context context public BeaconDatabase open helper new DbHelper this.context db helper.getWritableDatabase return this public.. iLon longitude n return result private static class DbHelper extends SQLiteOpenHelper public DbHelper Context context super..

Android AsyncTask and SQLite DB instance

http://stackoverflow.com/questions/7514021/android-asynctask-and-sqlite-db-instance

activity public class MyActivity extends Activity private DbHelper mDbHelper private ArrayList ExampleObject objects @Override.. public class MyActivity extends Activity private DbHelper mDbHelper private ArrayList ExampleObject objects @Override public void.. objects @Override public void onStop super.onStop if mDbHelper null mDbHelper.close mDbHelper null @Override public void..

Why is onUpgrade() not being invoked on Android sqlite database?

http://stackoverflow.com/questions/7647566/why-is-onupgrade-not-being-invoked-on-android-sqlite-database

onto my android emulator. I have set the db version in my DbHelper which inherits from SQLiteOpenHelper to 1. However when my 1st.. to 1. However when my 1st activity loads I instantiate my DbHelper which I would expect SQLiteOpenHelper to call onUpgrade as the.. is something I am missing. Where is the version that the DbHelper is using stored to compare against the new version Why is this..

Android SQLite Example [closed]

http://stackoverflow.com/questions/12015731/android-sqlite-example

EXISTS MyEmployees onCreate database Now you can use this class as below public class MyDB private MyDatabaseHelper dbHelper private SQLiteDatabase database public final static String EMP_TABLE MyEmployees name of table public final static String.. for employee public final static String EMP_NAME name name of employee @param context public MyDB Context context dbHelper new DatabaseHelper context database dbHelper.getWritableDatabase public long createRecords String id String name ContentValues.. EMP_NAME name name of employee @param context public MyDB Context context dbHelper new DatabaseHelper context database dbHelper.getWritableDatabase public long createRecords String id String name ContentValues values new ContentValues values.put EMP_ID..

Delete row in database table given one column value - which is a string

http://stackoverflow.com/questions/3314176/delete-row-in-database-table-given-one-column-value-which-is-a-string

_id long Name String x integer y integer I want to delete the row in the table that has Name myName. In onCreate dbHelper new DBAdapter this dbHelper.open Function in DBAdapter class public boolean deleteTitleGivenName String myName return dbHelper.delete.. integer y integer I want to delete the row in the table that has Name myName. In onCreate dbHelper new DBAdapter this dbHelper.open Function in DBAdapter class public boolean deleteTitleGivenName String myName return dbHelper.delete DATABASE_TABLE_2.. new DBAdapter this dbHelper.open Function in DBAdapter class public boolean deleteTitleGivenName String myName return dbHelper.delete DATABASE_TABLE_2 KEY_NAME myName null 0 Function call in java code dbHelper.deleteTitleGivenName myName this is where..

Is it possible to move the internal DB to the SDCard?

http://stackoverflow.com/questions/3436434/is-it-possible-to-move-the-internal-db-to-the-sdcard

like sdcard mydatabase.db Edit This is what I call in my application to access the database.... private static DBUtil dbHelper null public void openDatabase if dbHelper null dbHelper new DBUtil this.context dbHelper.openDataBase SQLiteDatabase.OPEN_READWRITE.. I call in my application to access the database.... private static DBUtil dbHelper null public void openDatabase if dbHelper null dbHelper new DBUtil this.context dbHelper.openDataBase SQLiteDatabase.OPEN_READWRITE public void closeDatabase if dbHelper.. application to access the database.... private static DBUtil dbHelper null public void openDatabase if dbHelper null dbHelper new DBUtil this.context dbHelper.openDataBase SQLiteDatabase.OPEN_READWRITE public void closeDatabase if dbHelper null dbHelper.close..

I'm getting a Database Object Not Closed Exception in SQLite (Android), but I'm explicitly closing my database… Help?

http://stackoverflow.com/questions/4940308/im-getting-a-database-object-not-closed-exception-in-sqlite-android-but-im

i 0 i jArray.length i JSONObject jObj jArray.getJSONObject i String userCheck jObj.getString username TagDBAdapter dbHelper new TagDBAdapter context dbHelper.open OPENING THE DATABASE Contact contact new Contact String first jObj.getString firstname.. jObj jArray.getJSONObject i String userCheck jObj.getString username TagDBAdapter dbHelper new TagDBAdapter context dbHelper.open OPENING THE DATABASE Contact contact new Contact String first jObj.getString firstname String last jObj.getString.. jObj.getString email contact.setHomePhone jObj.getString homephone contact.setWorkPhone jObj.getString workphone if dbHelper.checkForExisting userCheck true dbHelper.createContact contact else dbHelper.updateContactAuto userCheck contact dbHelper.close..

How to initialize sqlite database once from a helper class in Android

http://stackoverflow.com/questions/7444327/how-to-initialize-sqlite-database-once-from-a-helper-class-in-android

both of them for the whole application and can use them.That's something that I was trying to do DataBaseHelper dbHelper some code dbHelper new DataBaseHelper context ops_sys_tpl.sqlite null 1 DataBaseHelper.initialize context stampii_sys_tpl.sqlite.. for the whole application and can use them.That's something that I was trying to do DataBaseHelper dbHelper some code dbHelper new DataBaseHelper context ops_sys_tpl.sqlite null 1 DataBaseHelper.initialize context stampii_sys_tpl.sqlite dbHelper.copyDataBase.. dbHelper new DataBaseHelper context ops_sys_tpl.sqlite null 1 DataBaseHelper.initialize context stampii_sys_tpl.sqlite dbHelper.copyDataBase ops_sys_tpl.sqlite dbHelper.getDatabase dbHelper.executeQuery users objectId 2 dbHelper.executeQuery users..

Android: Overlay on Android Camera Preview

http://stackoverflow.com/questions/7466336/android-overlay-on-android-camera-preview

private Bitmap image2 private Bitmap bm public static String imagepath public static int x 1 private RdmsDbAdapter dbHelper @Override protected void onCreate Bundle savedInstanceState super.onCreate savedInstanceState setContentView R.layout.header.. null IncidentFormActivity.isDisable true DBAdapter instance created and connection opened. dbHelper new RdmsDbAdapter CameraActivity.this dbHelper.open setting up flags NewIncidentHelper nih new NewIncidentHelper nih.setUpNewIncident.. true DBAdapter instance created and connection opened. dbHelper new RdmsDbAdapter CameraActivity.this dbHelper.open setting up flags NewIncidentHelper nih new NewIncidentHelper nih.setUpNewIncident setting up incident_id String..

keeping a variable value across all android activities

http://stackoverflow.com/questions/8573796/keeping-a-variable-value-across-all-android-activities

value of the cursor row id to Profile class public class Overthelimit extends ListActivity private OverLimitDbAdapter dbHelper private Cursor cursor Called when the activity is first created. @Override public void onCreate Bundle savedInstanceState.. onCreate Bundle savedInstanceState super.onCreate savedInstanceState setContentView R.layout.main this.getListView dbHelper new OverLimitDbAdapter this dbHelper.open fillData registerForContextMenu getListView @Override protected void onActivityResult.. super.onCreate savedInstanceState setContentView R.layout.main this.getListView dbHelper new OverLimitDbAdapter this dbHelper.open fillData registerForContextMenu getListView @Override protected void onActivityResult int requestCode int resultCode..

Easy database access methods in Android

http://stackoverflow.com/questions/17234451/easy-database-access-methods-in-android

_id integer primary key autoincrement name text not null email text not null final Context context DatabaseHelper DBHelper SQLiteDatabase db public DBAdapter Context ctx this.context ctx DBHelper new DatabaseHelper context private static class.. not null final Context context DatabaseHelper DBHelper SQLiteDatabase db public DBAdapter Context ctx this.context ctx DBHelper new DatabaseHelper context private static class DatabaseHelper extends SQLiteOpenHelper DatabaseHelper Context context .. db.execSQL DROP TABLE IF EXISTS contacts onCreate db opens the database public DBAdapter open throws SQLException db DBHelper.getWritableDatabase return this closes the database public void close DBHelper.close insert a contact into the database..

Getting stored data from database into ListView.

http://stackoverflow.com/questions/3090041/getting-stored-data-from-database-into-listview

text mood text not null date text not null time text not null private final Context context private DatabaseHelper DBHelper private SQLiteDatabase db public DBAdapter Context ctx this.context ctx DBHelper new DatabaseHelper context private static.. context private DatabaseHelper DBHelper private SQLiteDatabase db public DBAdapter Context ctx this.context ctx DBHelper new DatabaseHelper context private static class DatabaseHelper extends SQLiteOpenHelper DatabaseHelper Context context .. db.execSQL DROP TABLE IF EXISTS titles onCreate db opens the database public DBAdapter open throws SQLException db DBHelper.getWritableDatabase return this closes the database public void close DBHelper.close Method for inserting login details..

column _id does not exist

http://stackoverflow.com/questions/3360605/column-id-does-not-exist

text null destination text null arrival text null ferry text null private final Context context private DatabaseHelper DBHelper private SQLiteDatabase db public DBAdapter Context ctx this.context ctx DBHelper new DatabaseHelper context private static.. context private DatabaseHelper DBHelper private SQLiteDatabase db public DBAdapter Context ctx this.context ctx DBHelper new DatabaseHelper context private static class DatabaseHelper extends SQLiteOpenHelper DatabaseHelper Context context.. db.execSQL DROP TABLE IF EXISTS port onCreate db opens the database public DBAdapter open throws SQLException db DBHelper.getWritableDatabase return this closes the database public void close DBHelper.close Method for inserting login details..

Multiple Table SQLite DB Adapter(s) in Android?

http://stackoverflow.com/questions/4063510/multiple-table-sqlite-db-adapters-in-android

TEXT NON NLS 1 CyclesDBAdapter.YEAR TEXT NON NLS 1 NON NLS 2 private final Context context private DatabaseHelper DBHelper private SQLiteDatabase db Constructor @param ctx public DBAdapter Context ctx this.context ctx this.DBHelper new DatabaseHelper.. DBHelper private SQLiteDatabase db Constructor @param ctx public DBAdapter Context ctx this.context ctx this.DBHelper new DatabaseHelper this.context private static class DatabaseHelper extends SQLiteOpenHelper DatabaseHelper Context context.. the db @return this @throws SQLException return type DBAdapter public DBAdapter open throws SQLException this.db this.DBHelper.getWritableDatabase return this close the db return type void public void close this.DBHelper.close The DBAdapter class..

how can i get the repeat alarm for week days using alarm manager in android?

http://stackoverflow.com/questions/7357469/how-can-i-get-the-repeat-alarm-for-week-days-using-alarm-manager-in-android

MediaPlayer mp AlertDialog.Builder alertbox Context ctx @Override public void onReceive Context context Intent intent DBHelper mDbh new DBHelper context null null 1 mDb mDbh.getWritableDatabase mDb.setLockingEnabled true mDba new DBAdapter context.. alertbox Context ctx @Override public void onReceive Context context Intent intent DBHelper mDbh new DBHelper context null null 1 mDb mDbh.getWritableDatabase mDb.setLockingEnabled true mDba new DBAdapter context mDba.open Cursor..

How to initialize sqlite database once from a helper class in Android

http://stackoverflow.com/questions/7444327/how-to-initialize-sqlite-database-once-from-a-helper-class-in-android

in DB handler class but I prefer to keep it seperate. public class MyTestDatabaseInstanceHolder public MyTestDBHandler DBHelper public static SQLiteDatabase m_ObjDataBase This is global variable to access across the applicaiton public static void createDBInstance.. This is global variable to access across the applicaiton public static void createDBInstance Context pContext if DBHelper null DBHelper new WLDBHandler pContext This will be your DB Handler Class m_cObjDataBase DBHelper.openAndCreateDataBase.. variable to access across the applicaiton public static void createDBInstance Context pContext if DBHelper null DBHelper new WLDBHandler pContext This will be your DB Handler Class m_cObjDataBase DBHelper.openAndCreateDataBase Initialze the..

How to create a Table with a column of type BLOB in a DBAdapter

http://stackoverflow.com/questions/7516933/how-to-create-a-table-with-a-column-of-type-blob-in-a-dbadapter

autoincrement SmileyDBAdapter.SOURCE BLOB SmileyDBAdapter.INFO private final Context context private DatabaseHelper DBHelper private SQLiteDatabase db Constructor @param ctx public DBAdapter Context ctx this.context ctx private static class DatabaseHelper.. open the db @return this @throws SQLException return type DBAdapter public DBAdapter open throws SQLException this.DBHelper new DatabaseHelper this.context this.db this.DBHelper.getWritableDatabase return this close the db return type void public.. type DBAdapter public DBAdapter open throws SQLException this.DBHelper new DatabaseHelper this.context this.db this.DBHelper.getWritableDatabase return this close the db return type void public void close this.DBHelper.close This is my DBAdapter..

how to display SQLite DataBase table?

http://stackoverflow.com/questions/7553203/how-to-display-sqlite-database-table

name text not null moves integer not null time text not null private final Context context private DatabaseHelper DBHelper private SQLiteDatabase db public DBAdapter3x3 Context ctx this.context ctx DBHelper new DatabaseHelper context private static.. context private DatabaseHelper DBHelper private SQLiteDatabase db public DBAdapter3x3 Context ctx this.context ctx DBHelper new DatabaseHelper context private static class DatabaseHelper extends SQLiteOpenHelper DatabaseHelper Context context .. DROP TABLE IF EXISTS contacts onCreate db opens the database public DBAdapter3x3 open throws SQLException db DBHelper.getWritableDatabase return this closes the database public void close DBHelper.close insert a contact into the database..

Is it possible to apply primary key on the text fields in android database

http://stackoverflow.com/questions/7591492/is-it-possible-to-apply-primary-key-on-the-text-fields-in-android-database

primary key autoincrement name text not null email text not null private final Context context private DatabaseHelper DBHelper private SQLiteDatabase db public DBAdapter Context ctx this.context ctx DBHelper new DatabaseHelper context private static.. context private DatabaseHelper DBHelper private SQLiteDatabase db public DBAdapter Context ctx this.context ctx DBHelper new DatabaseHelper context private static class DatabaseHelper extends SQLiteOpenHelper DatabaseHelper Context context .. db.execSQL DROP TABLE IF EXISTS contacts onCreate db opens the database public DBAdapter open throws SQLException db DBHelper.getWritableDatabase return this closes the database public void close DBHelper.close insert a contact into the database..

How to check if a value already exists in the database in Android

http://stackoverflow.com/questions/7820905/how-to-check-if-a-value-already-exists-in-the-database-in-android

private static final int DATABASE_VERSION 1 private final Context context private static DatabaseHelper DBHelper private static SQLiteDatabase db private static String TAG ## SecondActivityUserHelper ## public SecondActivityUserHelper.. private static String TAG ## SecondActivityUserHelper ## public SecondActivityUserHelper Context ctx this.context ctx DBHelper new DatabaseHelper context private static class DatabaseHelper extends SQLiteOpenHelper public DatabaseHelper Context context..

Deleting Row in SQLite in Android

http://stackoverflow.com/questions/7510219/deleting-row-in-sqlite-in-android

private static final String DATABASE_TABLE beaconTable private static final int DATABASE_VERSION 1 private DbHelper helper private final Context context private SQLiteDatabase db public BeaconDatabase Context context this.context context.. SQLiteDatabase db public BeaconDatabase Context context this.context context public BeaconDatabase open helper new DbHelper this.context db helper.getWritableDatabase return this public void close helper.close public long createEntry String name.. iName cursor.getDouble iLat latitude cursor.getDouble iLon longitude n return result private static class DbHelper extends SQLiteOpenHelper public DbHelper Context context super context DATABASE_NAME null DATABASE_VERSION @Override public..

Android AsyncTask and SQLite DB instance

http://stackoverflow.com/questions/7514021/android-asynctask-and-sqlite-db-instance

for each AsyncTask This is a simplified skeleton of my activity public class MyActivity extends Activity private DbHelper mDbHelper private ArrayList ExampleObject objects @Override public void onStop super.onStop if mDbHelper null mDbHelper.close.. each AsyncTask This is a simplified skeleton of my activity public class MyActivity extends Activity private DbHelper mDbHelper private ArrayList ExampleObject objects @Override public void onStop super.onStop if mDbHelper null mDbHelper.close mDbHelper.. private DbHelper mDbHelper private ArrayList ExampleObject objects @Override public void onStop super.onStop if mDbHelper null mDbHelper.close mDbHelper null @Override public void onResume super.onResume if mDbHelper null mDbHelper new DbHelper..

Why is onUpgrade() not being invoked on Android sqlite database?

http://stackoverflow.com/questions/7647566/why-is-onupgrade-not-being-invoked-on-android-sqlite-database

database I want to upgrade my database when it is installed onto my android emulator. I have set the db version in my DbHelper which inherits from SQLiteOpenHelper to 1. However when my 1st activity loads I instantiate my DbHelper which I would expect.. version in my DbHelper which inherits from SQLiteOpenHelper to 1. However when my 1st activity loads I instantiate my DbHelper which I would expect SQLiteOpenHelper to call onUpgrade as the db version is now newer. However it is never called. I'm.. now newer. However it is never called. I'm wondering if there is something I am missing. Where is the version that the DbHelper is using stored to compare against the new version Why is this not working I am actually copying the database from the assets..