android SQLite- write default values to database [duplicate]

Question

I have a database as follows. I want to write default values to this table when the table is created

db.execSQL("CREATE TABLE "+ DATABASE_TABLE + "(" +
    KEY_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
    KEY_CTYPE + " TEXT NOT NULL," +
    KEY_SNAME + " TEXT NOT NULL," +
    KEY_SNUMB + " TEXT NOT NULL," +
    KEY_USRN  + " TEXT NOT NULL," +
    KEY_PASS  + " TEXT NOT NULL," +
    KEY_EMPTY + " INTEGER);"
);

how should i do it?

No research, dude... sqlite.org/lang_createtable.html

m0skit0
– m0skit0

2013-11-06 13:15:55 +00:00
Commented Nov 6, 2013 at 13:15 — m0skit0
– m0skit0, Commented Nov 6, 2013 at 13:15

Abdul malik · Accepted Answer · 2013-11-06 13:19:03Z

1

in the oncreate after creating the Table add all the entries using a for loop

After

    db.execSQL("CREATE TABLE "+ DATABASE_TABLE + "(" +
            KEY_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
            + KEY_CTYPE + " TEXT NOT NULL,"
            +  KEY_SNAME + " TEXT NOT NULL,"
            +  KEY_SNUMB + " TEXT NOT NULL,"
            +  KEY_USRN + " TEXT NOT NULL,"
            +  KEY_PASS + " TEXT NOT NULL,"
            +  KEY_EMPTY + " INTEGER);"
    );

call your createEntry method in a loop 8 times and add the default values using ContentValues

answered Nov 6, 2013 at 13:19

Abdul malik

137 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

android SQLite- write default values to database [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related