I try to insert listview items name to a sqlite databace inside a For but I don't know how to do that. I guess this should work but faced error:
final SQLiteDatabase db = openOrCreateDatabase("LMDB", MODE_PRIVATE,
null);
db.execSQL("CREATE TABLE IF NOT EXISTS MyTable (id INT primary key autoincrement, onvan VARCHAR , ahamiyat INT, foriyat INT, olaviyat INT);");
String temp ="";
for(int i=0;i<lv.getAdapter().getCount();i++)
{
temp = AtomPayListAdapter.getItemTitle(i);
db.execSQL("INSERT INTO MyTable VALUES ('"+temp+"')");
}
db.close();
2nd Question:
when I delete a line from database is that "id INT primary key autoincrement" rearrange ids? (for example -1 rest of ids)
Aucun commentaire:
Enregistrer un commentaire