Android Question listview values / queries

[merlin2049er]

I wanted to pass either the value or position from the listview to a click event which runs a SQL query.

I can't use the value with my existing SQL query. I think I'd have to write a new SQL statement using the listview position, but that's not necessarily the index of my table.

So, how could I setup the listview with my table index initially. I think this will solve my problem.
Then I can pull up the record based on the table ID.

 

[LucaMs]

I wanted to pass either the value or position from the listview to a click event which runs a SQL query.

I can't use the value with my existing SQL query. I think I'd have to write a new SQL statement using the listview position, but that's not necessarily the index of my table.

So, how could I setup the listview with my table index initially. I think this will solve my problem.
Then I can pull up the record based on the table ID.

You can use DBUtils.ExecuteListView
(next time, post your query SQL)

 

[mangojack]

merlin .. Are you using DBUtils ..? if so I cannot help.

in one app I populate the listview with the .AddTwoLines2 method .. that allows you to set a return value for the click event. I use the table ID as that value .

'Populate the ListView with DB data setting the Record ID as return value ...
 
Cursor1 = SQL1.ExecQuery("SELECT * FROM MyTable")
  
   For i = 0 To Cursor1.RowCount - 1
     Cursor1.Position = i
     ID = Cursor1.GetInt("ID")
     Fname = Cursor1.GetString("FirstName")
     Lname = Cursor1.GetString("LastName")
  
     ListView.AddTwoLines2(Fname ,Lname ,ID)
   Next

Cheers mj

 

[merlin2049er]

I got the listview populated from a query and put it into 2 lines of listview data & a pic. Now, I'd like to drill down on that listview and run a query which selects that record.

 

[mangojack]

So, how could I setup the listview with my table index initially. I think this will solve my problem.
Then I can pull up the record based on the table ID.

have a look at ListView.AddTwoLinesAndBitmap2 then ... when you populate the list with your data and image .. the last supplied value is the table records ID which will be the return value on an List click event .. use that return value(table ID) to run your subsequent query.

Sub ListView_ItemClick (Position As Int, Value As Object)
   dim recID as String = Value
  
   Cursor1 = SQL1.ExecQuery("SELECT * FROM MyTable WHERE ID = '"& recID &"' ")

edit ... as only one record should exist I think you can use ..

   Cursor1 = SQL1.ExecSingleQuery("SELECT * FROM MyTable WHERE ID = '"& recID &"' ")

Cheers mj

 

[LucaMs]

In that case, mangojack, you need to query the db every time.

This is the "help" (intellisense) of DBUtils.ExecuteListView command:

This is the link to download DBUtils

 

[mangojack]

In that case, mangojack, you need to query the db every time.

That is correct .. every time the list is clicked .. which is what I understood merlin wished to do.

I wanted to pass either the value or position from the listview to a click event which runs a SQL query.

So, how could I setup the listview with my table index initially. I think this will solve my problem.
Then I can pull up the record based on the table ID.

is DBUtils absolutely necessary to achieve this .? or am I misunderstanding merlins problem ..

cheers mj

 

[LucaMs]

That is correct .. every time the list is clicked .. which is what I understood merlin wished to do.





is DBUtils absolutely necessary to achieve this .? or am I misunderstanding merlins problem ..

cheers mj

No mj, you are right. I've had too much haste and my poor English should restrain me

 

[mangojack]

LucasMS .. no problems .. Even knowing English I also have misunderstood other forum members problems

Cheers mj

 

[LucaMs]

LucasMS .. no problems .. Even knowing English I also have misunderstood other forum members problems

Cheers mj

 

[merlin2049er]

merlin .. Are you using DBUtils ..? if so I cannot help.

in one app I populate the listview with the .AddTwoLines2 method .. that allows you to set a return value for the click event. I use the table ID as that value .

'Populate the ListView with DB data setting the Record ID as return value ...

Cursor1 = SQL1.ExecQuery("SELECT * FROM MyTable")
 
   For i = 0 To Cursor1.RowCount - 1
     Cursor1.Position = i
     ID = Cursor1.GetInt("ID")
     Fname = Cursor1.GetString("FirstName")
     Lname = Cursor1.GetString("LastName")
 
     ListView.AddTwoLines2(Fname ,Lname ,ID)
   Next

Cheers mj

This looks like it should help me. I'd like to hide the table id in this list I'm building, and need to extract that ID when I click on that particular item in the list view.

 

[eps]

If you still want to use ListView, you can ListView2 and store the id in the tag part of the ListView. This is what I do for my Apps.



ETA : oops, sorry something like this :

ListView1.AddTwoLines2(Cursor.GetString("txt1"), Cursor.GetString("txt2"), Cursor.GetInt("_id"))

 

[merlin2049er]

oh , I'm using listview with bitmaps.

 

[merlin2049er]

I'll try putting it in the tag...

 

[mangojack]

Merlin .. Have you solved your problem ?

Are you using ListView.AddTwoLinesAndBitmap ? .. if so Use ListView.AddTwoLinesAndBitMap2
The last parameter / argument supplied to this method is the Records ID number.
It is Not Displayed in the List , It is returned as the value on a ListView Click Event.
You can then use this returned value (ID) to do a Query on that table ID recordset.

Sub ListView1_ItemClick (Position As Int, Value As Object)
  dim recID as String = Value

Cursor1 = SQL1.ExecSingleQuery("SELECT * FROM MyTable WHERE ID = '"& recID &"' ")

Cheers mj