Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- cursor = getReadableDatabase().rawQuery(
- String.format(
- "SELECT a.%s %s, question_id, a.text text, is_correct " +
- "FROM %s a JOIN %s q ON a.question_id = q.%s " +
- "JOIN %s l ON q.level_id = l.%s WHERE l.level = ? AND q.is_active = 1",
- BaseColumns._ID, BaseColumns._ID,
- ANSWERS_TABLE_NAME, QUESTIONS_TABLE_NAME, BaseColumns._ID,
- LEVELS_TABLE_NAME, BaseColumns._ID
- ),
- new String[]{Integer.toString(level)}
- cursor = getReadableDatabase().rawQuery(
- String.format(
- "SELECT a.%s %s, question_id, a.text text, is_correct " +
- "FROM %s a JOIN %s q ON a.question_id = q.%s WHERE q.category = ? AND q.is_active = 1 ",
- BaseColumns._ID, BaseColumns._ID,
- ANSWERS_TABLE_NAME, QUESTIONS_TABLE_NAME, BaseColumns._ID
- ),
- new String[]{thisQuestionCategory});
Add Comment
Please, Sign In to add comment