B4J Question (Solved) [B4X] B4XTable Column Id

aeric · Nov 9, 2022

Other fields that you can change are: Id, Searchable, Formatter, LabelIndex and DisableAutoResizeLayout. Not all of them will be covered in this tutorial.

You can also call GetColumn with the column id to get a column type. The id equals to the title by default (can be changed).

Q1: How can I change the column id?

Q2: After I have set the column id, can I use it with PreferenceDialog?

Eg: I have the title as "Birth Date" and key as "BirthDate" for PreferenceDialog json file, for B4XTable I have column header as "Birth Date" but I set the column id as "BirthDate" ?

[B4X] B4XTable - Cross platform, sortable, searchable, customizable table

B4XTable is a paged based table. The UI is made of a horizontal xCLV. The data is stored in an in-memory SQLite database. How to use? 1. Add a B4XTable with the designer. 2. Add the columns: B4XTable1.AddColumn("US County", B4XTable1.COLUMN_TYPE_NUMBERS) B4XTable1.AddColumn("Name"...

www.b4x.com

[B4X] Cross platform Editable B4XTable + Form Example

This example demonstrates several things: Cross platform code and files, similar to the way XUI2D games are organized: All the logic is implemented in a class named EditableTable. The module is located in the projects parent folder. The two asset files (list of animals - source; and the...

www.b4x.com

teddybear · Nov 9, 2022

aeric said:
Q1: How can I change the column id?

Q2: After I have set the column id, can I use it with PreferenceDialog?

Eg: I have the title as "Birth Date" and key as "BirthDate" for PreferenceDialog json file, for B4XTable I have column header as "Birth Date" but I set the column id as "BirthDate" ?

[B4X] B4XTable - Cross platform, sortable, searchable, customizable table

B4XTable is a paged based table. The UI is made of a horizontal xCLV. The data is stored in an in-memory SQLite database. How to use? 1. Add a B4XTable with the designer. 2. Add the columns: B4XTable1.AddColumn("US County", B4XTable1.COLUMN_TYPE_NUMBERS) B4XTable1.AddColumn("Name"...

www.b4x.com

[B4X] Cross platform Editable B4XTable + Form Example

This example demonstrates several things: Cross platform code and files, similar to the way XUI2D games are organized: All the logic is implemented in a class named EditableTable. The module is located in the projects parent folder. The two asset files (list of animals - source; and the...

www.b4x.com

A1. Dim Col as B4xTableColumn
Col = B4xTable1.AddColumn("Title", B4xTable1.COLUMN_TYPE...)
Col.id = "YourId"
A2. I don't think it is relation with column id

teddybear · Nov 9, 2022

aeric said:
Q1: How can I change the column id?

Q2: After I have set the column id, can I use it with PreferenceDialog?

Eg: I have the title as "Birth Date" and key as "BirthDate" for PreferenceDialog json file, for B4XTable I have column header as "Birth Date" but I set the column id as "BirthDate" ?

[B4X] B4XTable - Cross platform, sortable, searchable, customizable table

B4XTable is a paged based table. The UI is made of a horizontal xCLV. The data is stored in an in-memory SQLite database. How to use? 1. Add a B4XTable with the designer. 2. Add the columns: B4XTable1.AddColumn("US County", B4XTable1.COLUMN_TYPE_NUMBERS) B4XTable1.AddColumn("Name"...

www.b4x.com

[B4X] Cross platform Editable B4XTable + Form Example

This example demonstrates several things: Cross platform code and files, similar to the way XUI2D games are organized: All the logic is implemented in a class named EditableTable. The module is located in the projects parent folder. The two asset files (list of animals - source; and the...

www.b4x.com

A1. Dim Col as B4xTableColumn
Col = B4xTable1.AddColumn("Title", B4xTable1.COLUMN_TYPE...)
Col.id = "YourId"
A2. I don't think it is relation with column id

aeric · Nov 9, 2022

I found it.

B4X:

Private IdColumn As B4XTableColumn

IdColumn = GrdStaff.AddColumn(ID, GrdStaff.COLUMN_TYPE_TEXT)
IdColumn.Id = "id"

aeric · Nov 9, 2022

teddybear said:
A2. I don't think it is relation with column id

When I click Edit, I pass the data as a Map.
This Map has the key which is default to B4XTable header.
The problem I am facing when I use Localizator, the ~~key~~ header has changed to different language.
So I need a standard key disregard of different language.

B4X:

Dim Staff As Map = GrdStaff.GetRow(RowId)

teddybear · Nov 9, 2022

aeric said:
When I click Edit, I pass the data as a Map.
This Map has the key which is default to B4XTable header.
The problem I am facing when I use Localizator, the ~~key~~ header has changed to different language.
So I need a standard key disregard of different language.

B4X:

Dim Staff As Map = GrdStaff.GetRow(RowId)

How do you do Localizator in PreferenceDialog?
I mean LoadFromJson.

aeric · Nov 9, 2022

teddybear said:
How do you do Localizator in PreferenceDialog?
I mean LoadFromJson.

This is how I done.

B4X:

    Select Main.SYSTEM_LANGUAGE.ToUpperCase
        Case "ZH-CN"
            Dim JsonString As String = File.ReadString(File.DirAssets, "template_staff_zh-cn.json")
        Case "ZH-TW"
            Dim JsonString As String = File.ReadString(File.DirAssets, "template_staff_zh-tw.json")
        Case Else
            Dim JsonString As String = File.ReadString(File.DirAssets, "template_staff_en.json")
    End Select
    PrefDialog2.LoadFromJson(JsonString)

jahswant · Nov 9, 2022

aeric said:
This is how I done.

Genius

DarkoT · Nov 9, 2022

aeric said:
When I click Edit, I pass the data as a Map.
This Map has the key which is default to B4XTable header.
The problem I am facing when I use Localizator, the ~~key~~ header has changed to different language.
So I need a standard key disregard of different language.

B4X:

Dim Staff As Map = GrdStaff.GetRow(RowId)

View attachment 135801

Maybe will be better when you will using query from data (which is inside of B4Xtable) - like this:

Example code:

    Dim tblOpravila as B4XTable
    
    ' c0 = ID in table, C1 = link, C2 ... C9 = name, c10 = date, ...
    Dim Query as String = "select * from data where c0 = " & Id
    Dim rs As ResultSet = tblOpravila.sql1.ExecQuery(Query)
    Dim rec As Map
    rec.Initialize
    Do While rs.NextRow
        rec.Put("id", rs.Getint("c0"))
        rec.Put("name", rs.GetString("c9"))
    Loop
    rs.Close

In this case you can create map with fixed ID-s...

aeric · Nov 9, 2022

It is now working fine with Id.

B4J Question (Solved) [B4X] B4XTable Column Id

aeric

Expert

[B4X] B4XTable - Cross platform, sortable, searchable, customizable table

[B4X] Cross platform Editable B4XTable + Form Example

teddybear

[B4X] B4XTable - Cross platform, sortable, searchable, customizable table

[B4X] Cross platform Editable B4XTable + Form Example

teddybear

Well-Known Member

[B4X] B4XTable - Cross platform, sortable, searchable, customizable table

[B4X] Cross platform Editable B4XTable + Form Example

aeric

Expert

aeric

Expert

teddybear

Well-Known Member

aeric

Expert

jahswant

Well-Known Member

DarkoT

Active Member

aeric

Expert

Similar Threads

B4J Question (Solved) [B4X] B4XTable Column Id

Expert

Well-Known Member

Expert

Expert

Well-Known Member

Expert

Well-Known Member

Active Member

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency