B4A Library [Class] TableView - Supports tables of any size

Mahares · Jun 14, 2013

Are you missing the columns width definition below the line that starts with Next:

B4X:

Table1.SetColumnsWidths(Array As Int(180dip,100dip,90dip,100dip,90dip,80dip,50dip,90dip,100dip,150dip,150dip))

tonyp · Jun 15, 2013

How do I set/alter a single column width?

I need to make a column invisible by (I guess) changing its width to zero. But, I need to keep all other widths the same (without specifying the widths explicitly, again). How can I update only a single column width?

I suppose either something like SetColumnWidth(column,width), or
like SetColumnsWidths(GetColumnWidth(0),GetColumnWidth(1),WidthToChange,GetColumnWidth(3)...)

TIA

melamoud · Jun 15, 2013

In the latest class I added a sub to hide a specufic column ...

Sent from my SCH-I545 using Tapatalk 2

tonyp · Jun 15, 2013

I'm not sure I follow what you mean by "the latest class". I downloaded the latest just moments ago, and I see nothing that does what I want.
I need to hide and/or show a single column (not row).

For example, let's say I have a list that shows usernames and a hidden column with the related passwords. I want to be able to switch between Username and Password in the same screen space.

The password column width is initially zero (invisible), and to show the passwords, I need to simply switch the widths of Username and Password columns. Then to hide them, switch the widths back. The net effect is the table column remains the same size but a different (adjacent) column is shown in the same spot.

Any ideas?

melamoud · Jun 15, 2013

what version do you have ?

The latest I posted is 1.19 see it on this thread (need to go back to 5/16/2013 http://www.b4x.com/forum/additional...ss-tableview-supports-tables-any-size-26.html

call hideCol(col_num)
or unHideCol(col_num, new_width)

Nir

tonyp · Jun 16, 2013

Got it, but can't make it work

I had v1.11 from this thread. Apparently, you were referring to a different branch of this code.

So, I downloaded the one you mention, and I have been struggling to make it work.

I attach a minimal project that shows the problem.

To see the problem, change global variable ShowBug to True
(Uninitialized object - view - in SetColumnsWidths).

If the table has four columns (or five -- I didn't try with more), the program crashes, if only three columns, no problem.

Any ideas?

klaus · Jun 16, 2013

You initialize a table with three columns.
And then you try to add four headers, find the error !

Best regards.

tonyp · Jun 16, 2013

OOPS!!!!

Thanks

jatko · Jul 6, 2013

I have a questions:
Is there any possibility to chango background colour or font colour but only for same rows? For example for rows contains the "x" sign in the first column.
My program is designated for mobile salesmen. In need to change the look of row where the user clicked.

klaus · Jul 6, 2013

Currently it's not possible.
But you could modify the ShowRow routine in the table class module to do it.

Best regards.

Peter Simpson · Jul 21, 2013

OMG OMG OMG LOL.
I used to use a scroll view and another routine to do this, but wow @Erel this is just lightning fast in comparison.

I'm thinking about wrapping it into a library, as I've added some code to it and now I only need the library and not an extra module.

This is excellent, thank you and the other developers for their contribution to this class module

I might do some remote MySQL populating speed tests shortly.

klaus · Jul 21, 2013

If you have any code that could be intersting to other user, could you share it ?

Best regards.

Peter Simpson · Jul 22, 2013

No problem @klaus, here it is. The results can be seen in the screen shot below.

Basically the extra lines of code allows me to align gravity on any of the columns I want. What did I need this for. well currency columns are always usually justified to the right for accountancy purposes(old skool), I personally like to see Yes/No Boolean columns centered as well. Anyway below is the modified code that I added

First the 'Table' module.
Add the following line to 'Class_Globals'

B4X:

Private ColCellAlignment() As Int

Now to replace some code in the sub called 'Private Sub CreateNewLabels As Label()'
replace the following line

B4X:

l.Gravity = Alignment

with the following line

B4X:

If ColCellAlignment.Length > 0 Then l.Gravity = ColCellAlignment(I) Else l.Gravity = Alignment

Also replace the following Initialize string

B4X:

Public Sub Initialize (CallbackModule As Object, EventName As String, vNumberOfColumns As Int)

with the following line

B4X:

Public Sub Initialize (CallbackModule As Object, EventName As String, vNumberOfColumns As Int, CellAlignment() As Int)

Insert the following line at the beginning in Public Sub Initialize

B4X:

ColCellAlignment = CellAlignment

That's it for the 'Table' module, lets move on.

In your 'Main Module' or whatever 'Activity Module' you want, change the Initialize string for initializing the table to read the following(or to however you want the columns to look like in the table).

B4X:

Table2.Initialize(Me, "Table2", ResCol.Size, Array As Int(Gravity.FILL, Gravity.FILL, Gravity.FILL, Gravity.FILL, Gravity.RIGHT, Gravity.CENTER, Gravity.CENTER, Gravity.CENTER))

PLEASE NOTE:
You must make sure that you have the correct amount of columns added to the Initialisation string, in my case that's 8.

I hope that you can all follow my instructions. I tested it from scratch before posting it onto this forum...

BTW, whilst testing this table with an archived MySQL database. It was populating from starting the app to fully displaying the invoice list(screen shot below) in just 14.1 seconds. How many invoices is that you ask, well the answer is 14133 invoices as their invoices do not start from 1, they start from about 6000.

Wow that's not too bad really. That's basically 1000 lines per second on my N7 tablet(8 columns in this case), from an external database. There are MySQL database management apps that takes twice long as that on Google Play Store.

Okay usually I would limit database search query results on my apps to show 250 results(with an option to display more), but I wanted to test out this table, I was just being curious

Anyway the database is an MySQL database. I'm located in the UK, this particular database it situated about 375 miles away from my location.

Enjoy

buras3 · Aug 2, 2013

hello

i have replaced the new table from the old
now i can see only the header but not the rows ,
the rows are there because it's showing the small numbers of rows on the left bottom corner.

do someone knows this problem?

tanks
michael

klaus · Aug 3, 2013

Can you post your project as a zip file so we could have a look at it, IDE menu Files / Export As Zip.

Best regards.

buras3 · Aug 3, 2013

here is the code

you can go to "system report"

tank you

klaus · Aug 3, 2013

I had a look at your code, but I can't test it, the database Calls.db is missing.
And only looking at the code it's very difficult to find what is wrong.

Best regards.

buras3 · Aug 3, 2013

You probably test it on an emulator
you need call log for this app
but tanks anyway

klaus · Aug 3, 2013

You probably test it on an emulator

No, I tested it on both my devices a Nexus One and Asus TF700.
I get a NullPointer Exeption in line 67 in the Main module.

Best regards.

buras3 · Aug 3, 2013

i don't know
looks like your call log is empty

all the example for table are old one.
is there a example with 1.2 version?

or the version has table.size ?
i just need the table.size to know if the table is empty

B4A Library [Class] TableView - Supports tables of any size

Attachments

Expert

Member

Active Member

Member

Active Member

Member

Attachments

Expert

Member

Member

Expert

Expert

Expert

Expert

Attachments

Active Member

Expert

Active Member

Attachments

Expert

Active Member

Expert

Active Member