Search Results

Dim rs As ResultSet = B4XTable1.sql1.ExecQuery2(o(0), o(1)) Do While rs.NextRow Log(rs.GetString(B4XTable1.GetColumn("State").SQLID)) Loop rs.Close V1.10 - Fixes a bug with cell clicks on empty tables. V1.09 - The navigation buttons layout was fine tuned to be able to show three digits. V1.08 -
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...

You can change the header font and height using: B4XTable1.HeaderFont = xui.CreateDefaultBoldFont(20) B4XTable1.HeadersHeight =20dip the above two lines must be placed before you assign the columns data which is: B4XTable1.AddColumn("Name", B4XTable1.COLUMN_TYPE_TEXT).Width=100dip The above line
link: thank you. Excellent !!!
link: the page navigation and column header is taking up too much space. What are the parameters to change size at top. 132357 thank you in advance. Ron

The designer header color sets the background of the column headers. You can change the color of the top panel with: Sleep(0) 'this is required to let B4XTable load its layout. B4XTable1.pnlHeader.Color = B4XTable1.HeaderColor 'or any other value /code]
link: The designer says the header color should be white, but it is dark gray. Being as it is, the user only sees the light gray symbols in the header, whi
link: Put these 2 lines after you load the layout that has the B4XTable. That is the only place you need it.it would work: Sleep(0) 'Very important for thi

The worst thing is that when you click on it, the project crashes, because Row in this line (B4XTable source code) do not contains a number: Private Sub CellClicked (pnl As B4XView, LongClicked As Boolean) If DateTime.Now < LastCellClickEvent + 20 Then Return LastCellClickEvent = DateTime.N
link: It is a panel I add (layout file), so I have to remove it, to "restore" the initial-default state-look-layout. 1 - create the columns 2 - fill the B
link: I can understand removing a view, but I don't understand throwing away the panel. Why can't you add an empty view to that panel after removing the vie

Private Sub B4XPage_Created (Root1 As B4XView) Root = Root1 Root.LoadLayout("MainPage") Dim data As List data.Initialize B4XTable1.AddColumn("col1", B4XTable1.COLUMN_TYPE_NUMBERS) B4XTable1.AddColumn("col2", B4XTable1.COLUMN_TYPE_NUMBERS) For i = 1 To 150000 data.
link: Hello everyone, In a B4XTable, how can I make the header labels or fields bigger, to show all header data? (like the number of page that is shown)
link: Works perfect! Thanks.

101280 There are all kinds of ways to do it. A simple B4J only solution: 1. Add an invisible pane with the designer and set its background to GradientDrawable. Set the orientation to TOP_BOTTOM. 2. For Each col As B4XTableColumn In B4XTable1.VisibleColumns Dim p As B4XView = col.CellsLayout
link: Is it possible to add a gradient color in B4XTable header?

1. You are posting in the wrong forum. You should post in the questions forum. 2. You do not tell us what Nr is. 3. You did not tell us what your solution is to help the others. I use B4XTable. I like to learn more about it.
link: Have it ? Never mind.
link: Is it possible to have a running Nr as a row header no matter if sorted whatever way always starting with '1' ? I was playing a while with the VOID co

Trying to hide the columns with "even header". (Project attached) 123412123413
link: OK got it. Private Sub Button1_Click ' Resets visible columns. Dim toggle As Boolean = B4XTable1.VisibleColumns.Size = 10 B4XTable1.Visib
link: The following hides the even columns, but I haven't figured out how to bring them back. 'SHOULD hide even header columns. For i = B4XTable1.V
link: Yes, the order was wrong. I put refresh in wrong place. Is the original question a bug? Maybe you should post it there. Private Sub Button1_Click

They need to be placed in the correct place in the code. I tested them on my B4XTble and they work. The header code has to be before you assign the B4XTable columns, for the search it is after. If you want to attach a project, provided no sensitive data. some of the members including myself will ta
link: Here is the complete corrected project. Tested and works after a slight tuning. You needed to check the B4X Views library in the IDE library pane. It
link: sorry for the delay, User data are fake :) now header font is correct, but i have a error when set the search font java.lang.RuntimeException: Clas
link: There are several views in the header panel besides the search box text field. You have to go through all of them. As an example: B4XTable1.lblNumber.

To change the arrows colors: Sleep(0) ' B4XTable1.lblFromTo.TextColor= Colors.Cyan 'exple: 1 to 18 B4XTable1.lblNumber.TextColor=Colors.Red '1 the page numbers in red. you can also use XUI colors B4XTable1.ArrowsEnabledColor=Colors.green 'enable arrow color B4XTable1.ArrowsDi
link: specifically the arrows to turn the page and textsize Saludos
link: What about this: How to change text size in B4Xtable? (Solved)?
link: 1. I do. B4XTable loads a layout internally in DesignerCreateView. This requires calling Sleep(0) in B4XTable code as it is not possible to load a la

Powered by ColBERT