b4xtable

Check out the attached simple B4XTable app. The numbers in each column come from the same source, but they are often displayed as two wildly different numbers! Can anybody explain why, and how I can make sure that any numbers I display with COLUMN_TYPE_NUMBERS are as precise as can be? I'm...

If you run the attached B4XPages project, the app will crash when you attempt to search the B4XTable. If you comment out line 30, reducing the table column count from 8 to 7, you can search just fine. No problem. I also tried with 9 and 999 rows. The number of rows does not seem to matter.

I have this field in a B4XTable: COLUMN = TBLTRAD.AddColumn("BESTNUMBERS",TBLTRAD.COLUMN_TYPE_TEXT) CreateCustomFormat(COLUMN) SetColumnAlignment("BESTNUMBERS",Gravity.LEFT) This column (BESTNUMBER) fetchs several number. I don't know if it's possible to change color to a mayor value inside...

Hi everyone! I have two questions... 1. I have a B4XTable with 3 columns and 3 EditText, when a cell is clicked I want the 3 EditText show the content from the row clicked, for example: I want to do this to edit the row's content, I don't want to use ImputTemplate 2. with a button I want...

Hello everyone. I'm writing an Android version of a desktop app I wrote. Unfortunately, the B4J code hasn't used B4XTable, just the default TableView. Learning that in B4A there is no TableView view like in B4J, I came to the conclusion that I must use B4XTable, hence the following issues: 1...

I am playing around with the Excel import. Here is my code so far (taken over 1:1 from Erel 's example: #Region Project Attributes #MainFormWidth: 1200 #MainFormHeight: 600 #End Region Sub Process_Globals Private fx As JFX Private MainForm As Form Private B4XTable1 As...

I am using a resultset to load a B4XTable as suggested in the post "[B4X] B4XTable - Load data from SQL database". OK, everything is working fine. But my first attempt was: B4XTable1.AddColumn("Jogador", B4XTable1.COLUMN_TYPE_TEXT) B4XTable1.SetData( DBUtils.ExecuteList(Main.Banco...

I use one sub with code attached below that suppose to fill a list with a B4XTable rows. It works great, but if accidentally I have clicked on "Recents" button on the phone while the code is in the "Do While rs.NextRow " loop the app will crash with the error listed below. Not sure what would...

In a B4A application, in a B4XTable, I need to have a cell background color changed to Red color (for example). This cell is supposed to maintain its background color till a decision to change it. The issue I need to address is that : - after the respective cell's background was changed to a...

Hi guys, I need info... It's possible to add "submenu" into B4X table grid as submenu; which appears on CellLongClick from existing record in grid and user can choice which functionality will use... Thank you for help... Br, DaT

Hi, first, I am very grateful to the community for the tremendous work that has been carried out with the environment and libraries. I always search the forum, but today I came across a problem that I haven't been able to solve in days. I am implementing a table of type B4XTable to display data...

I work on the application, which should be used by Parkinson ill people to enter their good and bad times (on and off times). Ich have three columns in the sqlite database. In the first column the date is being saved, in the second one the time of the day. In the third the number should be...

Hello! I habe two columns in the B4XTable, one for the date data and the second for the time data. Wenn I set DateTime.DateFormat="dd.MM.yyyy" and try to load the table then I get in both columns date values. If I set DateTime.DateFormat="HH:mm" then I get in both columns time values. How can I...

Help is requested, i want to combine 2 cells value into 1 cell with line-break as shown blow

Hi I have a text comments field in my sqLite database tables. The contents of the field are optional and so the fields are NULL unless they have at least a string of zero length in them i.e. "" If you wish to use the search feature of b4xTables and you make the comments field searchable and...

Hi, I have a text comments field in my sqLite database tables. The contents of the field are optional and so the fields are NULL unless they have at least a string of zero length in them i.e. "" If you wish to use the search feature of b4xTables and you make the comments field searchable and...

Using the awesome library found here: https://www.b4x.com/android/forum/threads/b4x-b4xtable-multiple-rows-selection.102364/ I know there is probably a simple solution, but I can't quite figure it out. Is there a way to convert the example above to select only one row, but still deselect on...

B4XTblClmUtils is a b4x library (https://www.b4x.com/android/forum/threads/100383/#content). Allows you to set some properties of a B4XTableColumn (simple and default cells): - Text Size - Text Color - Font - Background color and border - Padding (B4A only). Example: Sub Globals Private...

Hi all, I need some help I have a B4XTable with some data. If I click on a row I wat the data of the clicked row to be visible/editable in an other screen (the blue one)

In the meantime I learnt that you can get the sum of a column in the B4XTable with Dim total As Double = B4XTable1.sql1.ExecQuerySingleResult($"SELECT sum(${Column.SQLID}) FROM data"$) But what if the user searched for a certain text. Do I have to work with the WHERE statement in the query or is...