Android Question B4XTable - all rows and no header

[samikinikar]

I am using the following example

https://www.b4x.com/android/forum/threads/b4x-b4xtable-load-data-from-sql-database.102520/

How can I display all the records (Max 31) with no top part ( no paging, no search, no total display )? Currently it displays 11 rows by default.

 

[Erel]

B4XTable is not vertically scrollable. The only way to show all items is to make it tall enough (you can also decrease RowHeight).

You can hide the top panel with:

B4XTable1.pnlHeader.Visible = False

 

[samikinikar]

Thank you

 

[yejian]

How to delete a row？

 

[samikinikar]

I guess you cannot delete the row.

 

[RB Smissaert]

How to delete a row？

I think you can delete a row quite easily, but unless I am mistaken you have to add some code to the B4XTable class (so use the class instead of the library).
This is what I added to the class:

Sub Class_Globals
Private lRowID As Long 'this is the SQLite rowid of the underlying table and view

Private Sub CellClicked (pnl As B4XView, LongClicked As Boolean)
If DateTime.Now < LastCellClickEvent + 20 Then Return
LastCellClickEvent = DateTime.Now
Dim column As B4XTableColumn = pnl.Parent.Tag
Dim Row As Int = pnl.Tag - 1
Dim e As String
If Row = -1 Then
If LongClicked Then
e = "_headerlongclicked"
Else
e = "_headerclicked"
HeaderClicked(column)
End If
If xui.SubExists(mCallBack, mEventName & e, 1) Then
#if B4i
If LongClicked Then FeedbackGenerator.RunMethod("impactOccurred", Null)
#End If
CallSub2(mCallBack, mEventName & e, column.Id)
End If
Else
Dim RowId As Long = VisibleRowIds.Get(Row)
lRowID = RowId '<<<< added to pick up the SQLite rowid

Now we could add a button to delete a row:

Private Sub btnDelRow_Click
sql1.ExecNonQuery2("delete from data where rowid = ?", Array As String(lRowID))
CountAll = CountAll - 1
Refresh
End Sub

RBS

 

[Erel]

I'm pretty sure that you can do it without modifying the B4XTable code.

Anyway, you should never post a new question in an existing thread. Start a new thread for further discussion.