mardi 7 juillet 2015

given a unique _id to an sqlite transaction

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