B4J Question b4xtable SearchField updated for 1st record

[ykucuk]

Hi,

When i try searchfield on b4xtable just 1st row updated by the result and get the attached error.



is it a bug ?

I tried with my app and b4xtable example app. same result.

Any help?

 

[Erel]

Please post the error message as text.

What are the steps to reproduce? Are you running one of the examples?

 

[ykucuk]

Hi Erel,

I found out that it's caused by the custom button on the row cell.

I added source code. Could you check, please ?

 

[Erel]

The number of items in each row must match the number of columns. You need to go over the loaded data and copy it to an array with 5 elements.

 

[ykucuk]

hi Erel,
I'm not an expert. Could you send me an example or any tutorial because I really don't have an idea what to do?

 

[Erel]

Load the data.
Create a new list.
Go over each item in the original list and copy the items to a new array with 5 elements:

For Each row() As String In Data
 Dim NewRow(5) As String
 NewRow(0) = row(0)
 ...
 NewData.Add(NewRow)
Next
B4XTable1.SetData(NewData)

 

[ykucuk]

could you check what's wrong with my row?

My Columns

SelectedColumn = B4XTable.AddColumn("Selected", B4XTable.COLUMN_TYPE_TEXT)
NumberColumn = B4XTable.AddColumn("HotelID", B4XTable.COLUMN_TYPE_TEXT)
B4XTable.AddColumn("Name", B4XTable.COLUMN_TYPE_TEXT)
NumberColumn = B4XTable.AddColumn("Rating", B4XTable.COLUMN_TYPE_TEXT)
NumberColumn = B4XTable.AddColumn("City", B4XTable.COLUMN_TYPE_TEXT)
NumberColumn = B4XTable.AddColumn("Phone", B4XTable.COLUMN_TYPE_TEXT)
B4XTable.AddColumn("PropertyType", B4XTable.COLUMN_TYPE_TEXT)
ActionColumn = B4XTable.AddColumn("Action", B4XTable.COLUMN_TYPE_TEXT)

My rows

For Each colResults As Map In Results

Dim row(8) As Object

row(0)=""

row(1)=colResults.Get("HotelID")

row(2) = colResults.Get("Name")

row(3) = colResults.Get("Rating")

row(4) = colResults.Get("Image")

row(5) = colResults.Get("Phone1")

row(6) = colResults.Get("PropertyType")

row(7) = ""


Data.Add(row)


Next

 

[Erel]

I don't see how I can help you with the information you provided.

 

[ykucuk]

I found what's the problem. it gives that error only cell value have "," inside and not come from a string variable.

Could you check row with one cell inside "Istanbul, Ankara" and try a search on B4XTable. ?

that's doesn't work. value came from JSON parser and included "," char


it works. the value set for a string variable



Value Column: PropertyType

 

[Erel]

I'm sorry but you keep ignoring my requests. I cannot further help you.

 

[ykucuk]

I'm sorry but you keep ignoring my requests. I cannot further help you.

ok.