I have an SQLite transaction which I want to assign a unique _id currently my _id is "INTEGER PRIMARY KEY AUTOINCREMENT"
' SQLiteStatement statement = database.compileStatement(sql); database.beginTransaction();
for (int i = 0; i < listQuestions.size(); i++) {
Questions currentQuestion = listQuestions.get(i);
statement.clearBindings();
// for a given column simply bind the data to be put inside that index
statement.bindString(2, currentQuestion.getQuestions());
statement.bindString(3, currentQuestion.getImage());
statement.bindString(4, currentQuestion.getOptionA());
statement.bindString(5, currentQuestion.getOptionB());
statement.bindString(6, currentQuestion.getOptionC());
statement.bindString(7, currentQuestion.getOptionD());
statement.bindString(8, currentQuestion.getOptionE());
statement.bindString(9, currentQuestion.getAnswerAns());
statement.bindString(10, currentQuestion.getAnswerImg());
statement.bindString(11, currentQuestion.getAnswerWhy());
statement.execute();
}
database.setTransactionSuccessful();
database.endTransaction();
}'
Aucun commentaire:
Enregistrer un commentaire