Search Results

When you call SetData the an in-memory db is created with the data. CellClick event Sub B4XTable1_CellClicked (ColumnId As String, RowId As Long) Dim RowData As Map = B4XTable1.GetRow(RowId) Dim cell As String = RowData.Get(ColumnId) Log(cell) End Sub B4XTable.GetRow returns a Map with
link: When try Switch ON ----> Error: SQL(query) error or missing database.
link: Hi Erel. I have this error: 'create custom filter B4XTable1.CreateDataView($"${NumberColumn.SQLID} > ?"$, Array(10)) Too many Parameters...

Sort(prjtable,prjtable.GetColumn("Nro")," DESC") Sub Sort (Table As B4XTable, Column As B4XTableColumn, SortMode As String) For Each c As B4XTableColumn In Table.Columns If c = Column Then c.InternalSortMode = SortMode Else c.InternalSortMode = ""
link: Hi All, I have B4XTable which has numbers stored as text (00001, 00002, etc.). I try to sort the column in code by setting InternalSortMode = "DESC"
link: Can you show the code for InternalSortMode and where you put it. Also, you can apply internalSortMode only to one column. Unless you prefer to post yo
link: Did you follow this protocol: B4XTable1.AddColumn("Nro", B4XTable1.COLUMN_TYPE_TEXT) Sleep(0) 'This line must be here after defining the col. It

Yes: B4XTable1.AddColumn("Name", B4XTable1.COLUMN_TYPE_TEXT).InternalSortMode = "DESC" 'or "ASC" 'or Dim c As B4XTableColum = B4XTable.AddColumn(...) c.InternalSortMode = "ASC" Set the internal sort mode field before you set the data.
link: is it possible to define a standart sort type? For example i have a Column ID with unsorded Numbers, i want B4XTable sort it by default after create i
link: Awesome, works like a charm. Thank you very much for this class!

In this code snippet you can see how to set a B4XTable column sort-able and/or searchable: If tablename = "category" Then Dim column As B4XTableColumn = B4XTbl1.GetColumn("") column.Searchable = False column.Sortable = False End If The if-statement is there in case y

Your code doesn't do anything. The query results will not have any effect on the table. Make all columns unsortable and: Sub B4XTable1_HeaderClicked (ColumnId As String) Dim col As B4XTableColumn = B4XTable1.GetColumn(ColumnId) B4XTable1.CreateDataView($"1=1 ORDER BY ${col.SQLID}, c0"$) En
link: I want to sort a B4XTable on multiple columns. For example, say I have "State" names in one column, and "City" names in the other. When I click on th
link: This didn't work: Private Sub (ColumnId As String) Dim col As B4XTableColumn = tbl_TableOfAssets.GetColumn(ColumnId) 'if not clicked c0...
link: You will need to do some work for this. It might be easier to modify B4XTable sort and implement it in the class directly. True.

https://www.b4x.com/basic4android/images/SS-2019-02-06_11.52.16.png Requires B4XTable v1.01+: https://www.b4x.com/android/forum/threads/b4x-b4xtable-cross-platform-sortable-searchable-customizable-table.102322/#content This example demonstrates the steps required to create cells with custom layout
link: 77161 B4J example is attached. Depends on xCharts.b4xlib: https://www.b4x./#content To make the layout simpler, the table width is static. The chart
link: Thanks EREL !!:):):)

Hello, I'm trying to sort a B4XTable by a column with numbers. I have define this column which name is "amount' like this: B4XTable1.COLUMN_TYPE_NUMBERS I try to sort the table on this column descending like this: Dim coln As B4XTableColumn = B4XTable1.GetColumn("amount") coln.InternalSortMode= "D
link: with Dim sy As String="SELECT * FROM tachats ORDER BY montant DESC" Sleep(0) chargerLesValeursDansB4Xtable(sy) where "chargerLesValeursDansB4Xtable(
link: The datas come from a sqlite table and this column 'amount" is also defined as NUMERIC.
link: Use ASC or DESC . The below will sort the table for you where the data of 1st col is bigger than 0 in descending order B4XTable1.CreateDataView($"c0 >

After you define the columns: Sleep(0) B4XTable1.lblFirst.Parent.Visible =False For Each c As B4XTableColumn In B4XTable1.Columns c.Sortable = False 'you can also remove the sort on individual columns Next Too many questions for one thread. I did not have time to look at all questio
link: Hi I'm starting to explore the b4xtable and have a couple of questions. Its the first time I am using it and have been searching and finding solution

Thanks on this Laurent, B4XTable has a Sort method similar with that for lists that I may have to explore. Cheers..
link: 'SortMode - ASC or DESC Sub Sort (Table As B4XTable, Column As B4XTableColumn, SortMode As String) For Each c As B4XTableColumn In Table.Colum
link: Give more informations. On what is based your B4XTable a SQL request, a list ? Not easy to help you with no information or code.
link: 109888 I am figuring-out the code on how to sort that B4XTable columns "Group" or "Group Rating" ascending or descending using code instead of clicki

You can't simply insert a record below the selected record because the B4XTable data displayed is stored in a SQLite in-memory database and the record goes to the end of the table. But what you can do is add an internal sort to the column in question say in this case it is called: 'Make'. When you

Powered by ColBERT