Databases
StackOverflow2013
Postsdbo
POLoad database column with query result not working
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLoad database column with query result not working
    text
    copied!<p>I'm trying to load a database column with a cursor result for my quiz app. The reason for this is that i want to populate a list view with the questions in a each category so i set up this:</p> <pre><code>public void putValues(){ for (int i = 0; i &lt; 18; i++) { Cursor contentCursor = null; contentCursor = mDB .rawQuery("select count(*) from questions_en where used = 0 and category" + " = " + i, null); if(contentCursor.getCount() &gt;0 ) contentCursor.moveToFirst(); if (contentCursor.isAfterLast()) { contentCursor.close(); mDB.close(); return; } int contentCursorInt = contentCursor.getInt(0); Cursor upateCursor = null; upateCursor = mDB.rawQuery("update categories_en set questions_count" + " = " + contentCursorInt + " where " + "_id" + " = " + i, null); upateCursor.moveToNext(); upateCursor.close(); contentCursor.close(); } } </code></pre> <p>so that when the user clicks an answer (on the question screen) <strong>used</strong> becomes 1(or any non-zero value) the query result changes. The above code works fine the very first time. Because i haven't set up the question screen, i added this query:</p> <pre><code>public void test(){ Cursor cus = mDB.rawQuery("update questions_en set used = 1 where category = 2 and _id = 146", null); cus.close(); } </code></pre> <p>to my DB Adapter and then called this method from my MainActivty</p> <pre><code> @Override public void onClick(View v) { TestAdapter mTest = new TestAdapter(MainActivity.this); mTest.createDatabase(); mTest.open(); mTest.test(); Log.d(DBHelper.TAG, " Worked "); mTest.close(); } }); </code></pre> <p>But when i click on this and go to my ListActivity I expected the value of category 2 to have changed since the query had just been carried out again. But it doesn't reduce. I pulled out my DB from DDMS(file explorer) and i found out that the query to _id = 146 actually didn't change <strong>used</strong> to 1. Any help on what may be the cause?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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