Databases
StackOverflow2013
Postsdbo
POBoolean values as integers from SQLite database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBoolean values as integers from SQLite database
    primarykey
    data
    text
    <p>I have a "true or false" type of quiz in making. So, two buttons, one true one false, and textview with question. I have an sqlite database imported in Assets folder. 4 columns in it: _id, question, correctAnswer, wrongAnswer. Every column INTEGER except question which is TEXT. So, for every correctAnswer column I set 0 or 1, depending if the answer is true or false. But, in the game, whatever the question is I get Wrong on my left TRUE button, and Correct on my right FALSE button. I don't know what I am doing wrong. Anyway, here's the code:</p> <pre><code>public class Kviz extends Activity implements OnClickListener{ Button true,false; TextView question; LinkedList&lt;Long&gt; mAnsweredQuestions = new LinkedList&lt;Long&gt;(); private String generateWhereClause(){ StringBuilder result = new StringBuilder(); for (Long l : mAnsweredQuestions){ result.append(" AND _ID &lt;&gt; " + l); } return result.toString(); } private class Answer { public Answer(int opt, boolean correct) { option = opt; isCorrect = correct; } int option; boolean isCorrect; } Runnable mLaunchTask = new Runnable() { public void run() { nextQuestion(); } }; Handler mHandler = new Handler(); final OnClickListener clickListener = new OnClickListener() { public void onClick(View v) { Answer ans = (Answer) v.getTag(); if (ans.isCorrect) { Toast.makeText(getApplicationContext(), "Correct!", Toast.LENGTH_SHORT).show(); mHandler.postDelayed(mLaunchTask,1200); } else{ Toast.makeText(getApplicationContext(), "Incorrect!", Toast.LENGTH_SHORT).show(); mHandler.postDelayed(mLaunchTask,1200); } } }; protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.kviz); inicijalizujVarijable(); nextQuestion(); } private void nextQuestion() { TestAdapter mDbHelper = new TestAdapter(this); DataBaseHelper myDbHelper = new DataBaseHelper(this); if(!myDbHelper.checkDataBase()){ mDbHelper.createDatabase(); } try{ mDbHelper.open(); Cursor c = mDbHelper.getTestData(generateWhereClause()); c.moveToFirst(); mAnsweredQuestions.add(c.getLong(0)); List&lt;Answer&gt; labels = new ArrayList&lt;Answer&gt;(); if (c.getInt(2)==1){ labels.add(new Answer(c.getInt(2), true)); labels.add(new Answer(c.getInt(3), false)); tacno.setTag(labels.get(0)); netacno.setTag(labels.get(1)); }else{ labels.add(new Answer(c.getInt(2), false)); labels.add(new Answer(c.getInt(3), true)); netacno.setTag(labels.get(0)); tacno.setTag(labels.get(1)); } true.setOnClickListener(clickListener); false.setOnClickListener(clickListener); } finally{ mDbHelper.close(); } } private void inicijalizujVarijable() { true = (Button) findViewById(R.id.bTacno); false = (Button) findViewById(R.id.bNetacno); question = (TextView) findViewById(R.id.tvPitanje); } public void onClick(View v) { } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmarjanbaz
    1. USmarjanbaz
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhy do you have a `correct answer` column and `wrong answer` column in your database? If they are all true/false there are only 2 possible outcomes, they get it or they don't so you could just use 1 column.
      singulars
      1. POBoolean values as integers from SQLite database
      1. USObieMD5
    2. COWell, I guess you are right, but that still does not solve my problem.
      singulars
      1. POBoolean values as integers from SQLite database
      1. USmarjanbaz
    3. COI need you to clarify what is happening, it does not make very much sense. I know you are not getting the desired outcome from pressing the answer buttons but the cases of which it happens, I do not understand.
      singulars
      1. POBoolean values as integers from SQLite database
      1. USObieMD5
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload