b4xtable

  1. MegatenFreak

    Android Question Questions about B4XTable (RTL orientation and having custom panels within the table)

    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...
  2. GMan

    B4J Question Problem with reading Excel.xls (B4XTable)

    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...
  3. jroriz

    B4J Question [SOLVED] B4XTable SetData with ExecutList as source. Is it possible?

    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...
  4. G

    Android Question [Solved][B4XTable] Crash in ResultSet if click on "Recents" phone button

    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...
  5. G

    Android Question [Solved] [B4XTable] Restore a cell's background color after SingleClick event

    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...
  6. DarkoT

    Android Question B4xtable - adding submenu on click

    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
  7. kosmocis

    Android Question B4XTable - Null error when using search field

    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...
  8. M

    Android Question how to format date and time columns in B4XTable

    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...
  9. M

    Android Question Formatting column in B4XTable

    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...
  10. manzoor

    Android Question Combine 2 cells in 1 cell B4XTable

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

    Wish B4xTable Search - Ignore null entries in fields when using the search feature.

    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...
  12. rgarnett1955

    Android Question B4xTable Search Fails If Text Field is NULL

    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...
  13. Eric McDonald

    Android Question B4XTable Select/Deselect Row

    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...
  14. LucaMs

    B4A Library [B4X] B4XTblClmUtils V. 1.0

    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...
  15. L

    B4J Question Retrieve data from B4XTable

    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)
  16. Yafuhenk

    B4J Question SOLVED B4XTable How to get the sum of all selected (searched) values in a column

    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...
  17. Yafuhenk

    B4J Question SOLVED B4XTable How to get the sum of all values in a column

    Does anyone know how I can get the sum of all values in a B4XTable column, so not only the ones that are visible? Thanks
  18. LucaMs

    Bug? B4XTable - ellipsize

    (B4J) [Note that the 0 in field "Bytes" is related to this other problem]
  19. A

    Android Question Load Mysql table into B4XTable

    Hello everyone. I'm trying to load Mysql database table data into B4XTable by using JRDC2. I can print results in logs. But the data is not showing in B4XTable columns it shows table empty. Anyone can explain how to load result rows into B4XTable? Thank you.
  20. LucaMs

    Wish B4XTable

    User view (EditText? PlusMinus?) to set how many pages forward and backward keys will "skip"
Top