Insert some rows into the table only once when the DataBase is created

Asked Nov 22 '13 at 07:19

Active Nov 22 '13 at 07:19

Viewed 235 times

I am trying to insert 2 rows into a table, when the DataBase is created for the first time .

Here is my code:

    private static class DatabaseHelper extends SQLiteOpenHelper {
    DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase _db) {
        _db.execSQL(DATABASE_CREATE_SQL);
        _db.execSQL(DATABASE_CREATE_SQL_TABLE2);

         _db.execSQL("INSERT INTO "+DATABASE_TABLE_2+" VALUES('com.android.music',1);");
         _db.execSQL("INSERT INTO "+DATABASE_TABLE_2+" VALUES('com.android.clender',1);");

    }

Please let me know if i am wrong . Is there any other way of doing it.

asked Nov 22 '13 at 07:19

user2717079

1

what's the error that you are getting?? – NoobEditor Nov 22 '13 at 07:27
source not found , i am fetching the records putting it into an array. – user2717079 Nov 22 '13 at 07:30
this might help : http://stackoverflow.com/questions/2071614/source-not-found-android – NoobEditor Nov 22 '13 at 07:37
Can you post what is in `DATABASE_CREATE_SQL_TABLE2`? – Szymon Nov 22 '13 at 07:57

Insert some rows into the table only once when the DataBase is created

0 Answers0