Databases
StackOverflow2013
Postsdbo
POAndroid Cursor strange behaviour
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAndroid Cursor strange behaviour
    primarykey
    data
    text
    <p>After many houres of bug searching in a big app, I have finally tracked down the bug. This logging captures the problem:</p> <pre><code>Log.d(TAG,"buildList, DBresult.getInt(1): "+DBresult.getInt(1)); Log.d(TAG,"buildList, DBresult.getString(1): "+DBresult.getString(1)); Log.d(TAG,"buildList, DBresult.getInt(4): "+DBresult.getInt(4)); Log.d(TAG,"buildList, DBresult.getString(4): "+DBresult.getString(4)); </code></pre> <p>The resulting output:</p> <pre><code>05-06 11:11:20.123: DEBUG/TodoList(18943): buildList, DBresult.getInt(1): 0 05-06 11:11:20.123: DEBUG/TodoList(18943): buildList, DBresult.getString(1): false 05-06 11:11:20.123: DEBUG/TodoList(18943): buildList, DBresult.getInt(4): 0 05-06 11:11:20.123: DEBUG/TodoList(18943): buildList, DBresult.getString(4): true </code></pre> <p>There are no backgroung threads running. As you can see the problem is that '0' is interpreted as false on one occasion, and as true on another. Since I am completely lost on how this can happen, I dont know how to proceed. What could possibly result in such a behaviour? Both the columns are of the type "boolean", i.e a numeric in sqlite. Unfortunately the string returned is the correct value, while the integer is always 0. If I export the database to my computer and check it with SQlite Administrator I can see that the values are correctly set, it is only the getInt()-function that always returns 0. I know for a fact that this works in other apps I have coded, and I dont know why this has stopped working.</p> <p>I have tried compiling the code under 2.0, 2.0.1 and 2.1, and it always appears. I can make my app runnable again by getting boolean values like this:</p> <pre><code>myBool= (DBresult.getString(0).equals("true")); </code></pre> <p>but that is both ugly and not optimized. Any suggestions on what is causing this behaviour is welcome.</p> <p>Cheers,</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USpgsandstrom
    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
    1. VO
      singulars
      1. POAndroid Cursor strange behaviour
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POAndroid Cursor strange behaviour
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POAndroid Cursor strange behaviour
      1. This table or related slice is empty.
      1. VTUpMod
    1. COcan you please add the insert statement and the table details ?
      singulars
      1. POAndroid Cursor strange behaviour
      1. USKaran
    2. COThanks, due to your request I ran straight into the source of the problem =)
      singulars
      1. POAndroid Cursor strange behaviour
      1. USpgsandstrom
    3. COI find it fascinating that there is no getBoolean method implemented. Still, I tend to use ints instead of booleans because space is so cheap.
      singulars
      1. POAndroid Cursor strange behaviour
      1. USKieveli
 

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