Search Results

After re-reading your question .. appologies. Try this Sub Button1_Click Dim column As B4XTableColumn = B4XTable1.GetColumn("Name") If column.InternalSortMode = "ASC" Then column.InternalSortMode= "DESC" Else column.InternalSortMode= "ASC" End If B4XTable1
link: And the sample code was using column_type_TEXT and I need it for column_type_DATE. Before adding .InternalSortMode = "ASC" the code was working

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.

'SortMode - ASC or 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 = "" E
link: It worked, after removing the "If" (maybe a typo error) from "If c.InternalSortMode = SortMode" .. Thank you Erel!

The property InternalSortMode of a B4XTABLE column may be set by code with "ASC" or "DESC". In that case : Header displays an arrow showing the direction of the sorting option (ascending or descending) Content column is sorted, case sensitive As this property is probably added to the SQLite sort c
link: @Erel : I found the way to modify B4XTable.b'xlib in the forum thanks to @DonManfred ! I will investigate Sorry for the spam :rolleyes:
link: @Erel : I did it :) In attachment, the library version 1.24 and below the modifications. Sub BuildQuery ... If Not("COLLATE NOCASE ".Contains(
link: Hi, unfortunately, I am not able to modify the file B4XTable.b4xlib or I don't know the way to (@Erel ?). May I suggest a simple fix to deal with the

sort: B4XTable .InternalSortMode B4XTable1.AddColumn("Name", B4XTable1.COLUMN_TYPE_TEXT).InternalSortMode = "DESC" 'or "ASC" 'or Dim c As B4XTableColum = B4XTable.AddColumn(...) c.InternalSortMode = "ASC" Map https://www.b4x.com/android/forum/threads/b4x-b4xcollections-more-collections.101071/ Ar

A simple search for InternalSortMode gives the best results available in the forum: https://www.b4x./?query=InternalSortMode Try it.
link: I will try Google. Thanks! That does find more. I was using InternalSortMode B4J and it finds a lot of mode ,sort, and internal
link: I use Google search: site:b4x.com -"Search Results" InternalSortMode
link: How can I search for something like InternalSortMode but not pieces of it( or something like sort on b4xtable column ). What I find mostly is

Sorry. I could not tell if your thread is a wish, example or tutorial, or if you are addressing it to Erel or everyone else. But, sometimes the choice of words in the properties or methods makes it difficult to tell what you need to follow it with. In this case: Instead of: c.InternalSortMode , I
link: What I'm about to write would be more suitable for Erel's thread: "Code Smells" - common mistakes and other tips, but it's just my opinion and I don'

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 your project
link: Sort(prjtable,prjtable.GetColumn("Nro")," DESC") Sub Sort (Table As B4XTable, Column As B4XTableColumn, SortMode As String) For Each c As B4XTabl
link: Rows prono = NumberFormat2(row(0), 5, 0, 0, False) prj = " " & row(1) data.Add(Array(prono, prj)) Next Wait For (prjt
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"

Yes, with the cast it works also as parameterized query. Probably best for uniformity to keep it all parameterized, so that Sub now is like this: Public Sub BuildQuery (WithPageLimit As Boolean) As Object() Dim c As Int Dim n As Int Dim SortColumn As String Dim strFind As Stri
link: Just started to experiment with B4XTable, using the provided example project as provided by Erel in the first post regarding B4XTable. I added some ex
link: Indeed it seems the problem was with the provided argument not being handled properly. No idea why exactly that is. If I hard code the argument (the l

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