Databases
StackOverflow2013
Postsdbo
POonitemclick() returns wrong value
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POonitemclick() returns wrong value
    primarykey
    data
    text
    <p>i have an onitemclicklistener() implemented in my listview that shows all my database info</p> <pre><code>onitemclick((AdapterView&lt;?&gt; parent, View viewClicked, int position, long bezoeknummer) </code></pre> <p>shown snippet of code returns me the first column value of that specific database row.</p> <p>how can i make it return the 2nd column of that database row? </p> <p>i tried already to make my cursor query to read the desired (2nd column value) as _id instead of my first row value but then my program crashes</p> <p>edit,</p> <p>i have following code for the onitemclick</p> <pre><code>private void herkenlijstklik() { ListView bezoelijst = (ListView) findViewById(R.id.listViewAbezoe); bezoelijst.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView&lt;?&gt; parent, View viewClicked, int position, long bezoeknummer) { Log.i("herkenlijstklik", "nummer gepaseerd door onitemclick, zou moeten hetzelfde zijn als bezoeknummer = " + bezoeknummer); } }); </code></pre> <p>my cursor for my listview is formed as shown below out of my database</p> <pre><code>public Cursor leesallegegevens() { String waar = null; Cursor c = onzedatabase.query(true, databasetabel, allekolommen, waar, null, null, null, null, null); if (c != null) { c.moveToFirst(); } Log.i("cursor leesallegegevens", c.toString()); return c; } </code></pre> <p>to ask again my question:</p> <p>my database exists of multiple columns, the function Onitemclick() returns me the first column of that database what i my variable called long bezoeknummer to return is in the 2nd column</p> <p>as the code is shown i do not have any errors in the logcat, only the wrong value returned</p> <p>please help me how to return the desired value, please do not hesitate to ask more questions if necesary</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USkeuninkske
    1. USkeuninkske
    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. POonitemclick() returns wrong value
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO`returns me the first column value of that specific database row` the shown snippet doesn't return anything. Please show the relevant code and the stack trace from logcat for the crash.
      singulars
      1. POonitemclick() returns wrong value
      1. USSimon
    2. COThe shown snippet also doesn't indicate that a database is involved in any way.
      singulars
      1. POonitemclick() returns wrong value
      1. USTanis.7x
    3. COPlease complete your question with: relevant code, logcat and complete scenario. Thanks!
      singulars
      1. POonitemclick() returns wrong value
      1. USfasteque
 

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