Hi,

I'm trying to change PAGE_SIZE using Android Java API but not successful.
Using onCreate method of SQLiteOpenHelper class, I called setPageSize() 
before creating tables as follows.

     ...
     private static class DatabaseHelper extends SQLiteOpenHelper {

         DatabaseHelper(Context context) {
             super(context, DB_NAME, null, DB_VERSION);
         }

         @Override
         public void onCreate(SQLiteDatabase db) {
             db.setPageSize(PAGE_SIZE);
             db.execSQL(createSQL);
         }

         @Override
         public void onUpgrade(SQLiteDatabase db, int oldVersion, int 
newVersion) {
             db.execSQL(dropSQL);
             onCreate(db);
         }
     }
     ...
     db = mOpenHelper.getWritableDatabase();
     ...

But I could not change it.
What's wrong?  How can I change it with Android API?


Thank you in advance.
kw.



_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to