b4xtable

  1. Pxs

    B4J Question InlineEditing b4xTable help with tabbing beetween fields

    Hello, I'm trying the InlineEditing class with b4xtable. Is there a way to tab from a field to the next? To quickly fill all the fields of a row without having to use the mouse to click on them? Right now tab only jumps from the current selected field to the Search textfield... I tried to...
  2. DarkoT

    Share My Creation DatTable - extension of B4XTable

    Hi to all, Based on the B4XTable library, I have made a small enhancement that is extremely practical for the user. It enables three additional functionalities: a) Reordering of row sequence and column lengths b) Resetting the saved layout (to default layout) c) Exporting data to Excel The...
  3. LucaMs

    Android Code Snippet [B4X] [B4XTable] Clear data only (keeping the table structure)

    Edit: Erel's way is much simpler! Author: @cklester (https://www.b4x.com/android/forum/threads/b4xtable-clearing-data.142729/post-904607) Sub ClearB4XTable(xTable As B4XTable) Dim lstData As List lstData.Initialize xTable.SetData(lstData) End Sub Note to Erel: this is not "cool":
  4. JonnyCav

    Android Question Do While loop on B4XTable

    I create a B4XTable from 3 sqlite tables and the table builds. (The table is static) I created an array list from the table but I'm thinking that must be overkill. All I want to do is simply INSERT INTO an sqlite table by looping through the table. What would be the best method? We're only...
  5. JonnyCav

    Android Question B4XTable and saving to data

    I have successfully created a table and saved the data in my 'Downloads' folder (because it's a report for distribution outside the app users). However, the text looks like this: [Ljava.lang.Object;@8f7df58 [Ljava.lang.Object;@da718b1 [Ljava.lang.Object;@391a196 [Ljava.lang.Object;@441b117...
  6. LucaMs

    B4J Library [B4X] lmB4XTableExt

    B4XLib library that adds useful functionalities to B4XTable. Please, see: https://www.b4x.com/android/forum/threads/b4x-lmb4xtableext.158817/
  7. LucaMs

    B4A Library [B4X] lmB4XTableExt

    B4XLib library that adds useful functionalities to B4XTable. Currently for B4A and B4J. The main feature of this library, although not the only one, is having a type of filtering similar to that of Excel, i.e. with the column headers that "transform" to allow you to easily insert filters (one...
  8. LucaMs

    B4A Library lmB4XTableEx - Preview

    UPDATE. Ready: https://www.b4x.com/android/forum/threads/b4x-lmb4xtableext.158817/ --------------------------------------------------------------------------------------------------- I can't resist! :) I am pleased (not happy 😄 ) to preview one of my libraries (B4XLib, therefore with source...
  9. LucaMs

    Wish [B4X] B4XTableColumn DateFormat property

    https://www.b4x.com/android/forum/threads/b4x-b4xtable-and-date-fields.158519/post-973153
  10. LucaMs

    B4J Question [B4X] B4XTable and date fields

    I'm struggling quite a bit with this topic, date type fields in B4XTable. I finally 😓💦 think I understand what the problem is and I'm afraid I can't solve it. The aim would be to automatically read a date DB field (DATE, DATETIME, TIMESTAMP) and display it in a B4XTable column set as...
  11. Mariano Ismael Castro

    B4J Tutorial B4XTable - B4XLocalizator

    Hola, si has utilizado [B4X] Localizator - Localiza tus aplicaciones B4X, sabes que tienes que usar Excel para añadir las claves y luego traducir cada una de ellas al idioma de destino. Con esta herramienta agregas las claves directamente al B4XTable y luego puedes hacer clic en las celdas para...
  12. R

    Android Question B4XTable, attach memory DB to main SQLite (file based) DB

    Trying to run a query on the B4XTable memory DB and move the resulting data directly to a table in the main SQLite (file based) table. I trying to do this by attaching the B4XTable memory DB to the main DB and then running that query from the main DB. The reason for doing it like this is that...
  13. W

    B4J Code Snippet [B4XTable] B4XTableSettingsExplorer - shows the impact of changing B4XTable properties et al

    The title more or less says it all. I wanted to better understand the myriad of properties of the B4XTable, and here they are. Change a property and immediately see which part of the table is impacted. Here's what it covers (these are the options in the ChoiceBox): --- Properties ---...
  14. Alain75

    Wish B4XTableColumn InternalSortMode

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

    Android Question B4XTable number of table rows after a search

    The B4XTable class (in the B4X lib file) has the variable mCurrentCount, indicating the total number of rows of the table. However it seems this is not available when you have run a filter (SQL with where clause). For this reason the last page button (>|) is always greyed out as the last page...
  16. R

    Android Question Problem with Length function in B4XTable SQL

    Just started to experiment with B4XTable, using the provided example project as provided by Erel in the first post regarding B4XTable. I added some extra options to the search facility, edited the Subs: Public Sub BuildQuery Private Sub ImplUpdateDataFromQuery Public Sub BuildQuery...
  17. R

    Android Question B4XTable search for empty values(SOLVED)

    Just experimenting with the B4XTable. I added some extra options to search column values along these lines: For Each col As B4XTableColumn In VisibleColumns If col.Searchable Then For n = 0 To arrCheckConditions(c) - 1 strFind =...
  18. H

    B4J Question Replace TableView With B4XTable

    What should I do to replace TableView With B4XTable in an old B4J project? Is it difficult and may interfere with the software process?
  19. G

    Android Question B4x table Create data view with max and min value in

    I need to show the maximum and minimum marks in b4xtable. I get the data from Google sheet and I am displaying it in b4xtable. I tried using the below code to get maximum and minimum data . Obviously the code is wrong as I get the error : "java.sql.SQLException: [SQLITE_ERROR] SQL error or...
  20. DarkoT

    B4J Question TableView - store column order

    Hi, I want to implement TableView instend of B4xTable because TableView has drag&drop columns sort options and columns can be resized with a mouse. I want to implement also the "save layout" option wich will allow user to resize columns, hide columns and make unique positions for columns in...
Top