Search Results

Allows disabling the search highlighting feature. V1.20 - Many changes under the hood. New RefreshNow method that refreshes the table synchronously. SetData returns a ResumableSub object and can be used with Wait For to (asynchronously) wait for the data to be ready. New SearchVisible field and desi
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...

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

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!

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

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
link: In this sub: Private Sub IE_GetUpdatedValue (FC As FocusedCell) As Object Change this line: If Numbers.ContainsKey(sDetails) Then Return B4XPlusMinus1

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.

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: The datas come from a sqlite table and this column 'amount" is also defined as NUMERIC.
link: with Dim sy As String="SELECT * FROM tachats ORDER BY montant DESC" Sleep(0) chargerLesValeursDansB4Xtable(sy) where "chargerLesValeursDansB4Xtable(
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 >

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: Or simply stated, what would be the code to sort a B4XTable column ascending or descending?

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 !!:):):)

'3) Change color of sort direction icon which is not added to the panel until ' panel is clicked - this is a workaround and there might be better ways 'Go to internal libraries, unzip B4XTable, extract B4XTable.bas and B4XTable.bal (in Files) 'Copy B4XTable.bal to project Files and B4XTable.bas to
link: B4XTable V1.18 released - lblSort (sort arrow) is now public.
link: This code will not work perfectly as the sort icon can be updated again after the HeaderClicked event in some cases. You can use this code to change
link: Erel added this to the B4XTable in ver. 1.18: B4XTable1.lblSort.textColor= XUI.Color_Green It would stand out more if you can change the color based

Powered by ColBERT