Android Question customlistview Value

[MroBurk]

Hi I created the db with a customlistview, I need Help because the Customlistview_clickItem doesn't work... It seems that it cannot take the value of the list. Can you Help me? When the Item is clicked, it opens the next activity with the last row, not by the clicked... thanks!!

 

[LucaMs]

To find the bug you should have logged Value.

You have not associated a value to the items of the CLV.

Listen to a newbie: get started right away with B4XPages projects, rather than "pure" B4A.

 

[mangojack]

To begin with ... You have not passed a Value when adding to the CLV...

CustomListView1.Add(p, "")

Private Sub CustomListView1_ItemClick (Index As Int, Value As Object)
Status = "U"
rs= Starter.sql.ExecQuery("SELECT * FROM Table1 WHERE Name ='" & Value & "'")

Make the following changes ...

CustomListView1.Add(p, NOME)

Private Sub CustomListView1_ItemClick (Index As Int, Value As Object)
Status = "U"
rs= Starter.sql.ExecQuery2("SELECT * FROM Table1 WHERE Name = ? ", Array As String(Value))

 

[LucaMs]

To begin with ... You have not passed a Value when adding to the CLV...

CustomListView1.Add(p, "")

Private Sub CustomListView1_ItemClick (Index As Int, Value As Object)
Status = "U"
rs= Starter.sql.ExecQuery("SELECT * FROM Table1 WHERE Name ='" & Value & "'")

Make the following changes ...

CustomListView1.Add(p, NOME)

Private Sub CustomListView1_ItemClick (Index As Int, Value As Object)
Status = "U"
rs= Starter.sql.ExecQuery2("SELECT * FROM Table1 WHERE Name = ? ", Array As String(Value))

That is: do what @LucaMs did in the project he attached

 

[mangojack]

That is: do what @LucaMs did in the project he attached

sorry ... unaware you had already posted a solution.

 

[MroBurk]

It works!!! great!!! thanks!!