B4A Library Grid/Table and ListView Library

Descartex · Aug 21, 2013

Thanks a lot...
i´ll try that way

jrat · Aug 31, 2013

Please help my find error.
I create SQL table

B4X:

db.ExecNonQuery ("CREATE TABLE test (Id INTEGER PRIMARY KEY , parentId INTEGER,  Name TEXT, isFolder TEXT);")

Next i create Grid, the colums init use this code:

B4X:

cur1 = db.ExecQuery ( "SELECT * FROM test" )
For col = 0 To NumberOfColumns - 1
    NameCol=cur1.GetColumnName(col)
    cc(col).Initialize2 (NameCol , NameCol , 100%x/NumberOfColumns , Gravity.CENTER_VERTICAL + Gravity.CENTER_HORIZONTAL )
    gg.ColAppend ( cc(col) )
Next

After them i want set same properties for rows

B4X:

For r=0 To gg.RowCount-1
      If gg.GetValueSafe2(r , "isFolder")=1 Then
        gg.PropSetColor(r,Colors.Yellow)
        gg.PropSetTextColor(r,Colors.Black)
    End If
Next

Error:
If gg.GetValue2(r , "isFolder")=1 Then
java.lang.ArrayIndexOutOfBoundsException

stefanobusetto · Aug 31, 2013

yust to be sure
create the table using uppercase field names

jrat · Aug 31, 2013

I rename field

B4X:

Main.db.ExecNonQuery ("CREATE TABLE test (Id INTEGER PRIMARY KEY , parentId INTEGER,  Name TEXT, ISFOLDER TEXT);")

and use

B4X:

 If gg.GetValueSafe2(r , "ISFOLDER")=1 Then

and error is repeat

if i use

B4X:

  Dim cc(5) As xnGridCol
  cc(0).Initialize2 ( "Id" , "Id" , 10%x , Gravity.CENTER_VERTICAL + Gravity.CENTER_HORIZONTAL )
  gg.ColAppend ( cc(0) )
  cc(1).Initialize2 ( "F" , "isFolder" , 0 , Gravity.CENTER_VERTICAL + Gravity.CENTER_HORIZONTAL )
  gg.ColAppend ( cc(1) )
  cc(2).Initialize2 ( "Op" , "Opened" , 0 , Gravity.CENTER_VERTICAL + Gravity.CENTER_HORIZONTAL )
  gg.ColAppend ( cc(2) )
  cc(3).Initialize2 ( "P" , "parentId" , 0 , Gravity.CENTER_VERTICAL + Gravity.CENTER_HORIZONTAL )
  gg.ColAppend ( cc(3) )
  cc(4).Initialize2 ( "Name" , "Name" , 90%x , Gravity.LEFT + Gravity.CENTER_HORIZONTAL )
  gg.ColAppend ( cc(4) )

all work fine

stefanobusetto · Aug 31, 2013

really strange!
i can't see the problem
the code looks like the same

jrat · Aug 31, 2013

this is my code

stefanobusetto · Sep 1, 2013

i've fixed a bug in the GetValueSafe2 function
thanks for the bug reporting

TheMightySwe · Oct 3, 2013

Hi Stefano,

I was wondering if you could add support for different typefaces? I would love to have a monospace font in the grid.

stefanobusetto · Oct 4, 2013

it's a nice idea!
i don't think it'll be a problem to add this feature

stefanobusetto · Oct 6, 2013

sample for a grid using the multiline row feature

RelativeLayout reference
http://developer.android.com/reference/android/widget/RelativeLayout.html
Constants:
LEFT_OF = 0;
RIGHT_OF = 1;
ABOVE = 2;
BELOW = 3;
ALIGN_BASELINE = 4;
ALIGN_LEFT = 5;
ALIGN_TOP = 6;
ALIGN_RIGHT = 7;
ALIGN_BOTTOM = 8;
ALIGN_PARENT_LEFT = 9;
ALIGN_PARENT_TOP = 10;
ALIGN_PARENT_RIGHT = 11;
ALIGN_PARENT_BOTTOM = 12;
CENTER_IN_PARENT = 13;
CENTER_HORIZONTAL = 14;
CENTER_VERTICAL = 15;

laiberica · Oct 9, 2013

Hello it is possible add or delete rows now?

TheMightySwe · Oct 9, 2013

Is it possible to add a "Tag" to the rows så you can store a database ID there?

stefanobusetto · Oct 10, 2013

@laiberica
you can use
ColInsert/ColAppend/ColDelete
to add and remove columns
but only before the grid is created
and
RowInsert/RowAppend/RowDelete
or also
CursorInsert/Append
JsonInsert/Append
at any time

if you want there are some examples
in the xnGridSample app i've posted here
http://www.b4x.com/android/forum/threads/grid-library.16381/

stefanobusetto · Oct 10, 2013

@TheMightySwe
yes
you can add one or more zero width columns to the grid
and you'll be able to store the values you need
zero width columns are not visible

TheMightySwe · Oct 10, 2013

stefanobusetto said:
@TheMightySwe
yes
you can add one or more zero width columns to the grid
and you'll be able to store the values you need
zero width columns are not visible

I know that, thats how I do it now. But sometimes you want to attach more than just an ID.

aviario · Oct 10, 2013

Hello stefanobusetto, when you scroll the grid horizontally have any event to detect it?

un saludo
Paco

TheMightySwe · Oct 11, 2013

And the "LongClick" event on a line or cell would be very useful.

Sorry for all the ideas, you have done a very fine job with this grid.

stefanobusetto · Oct 11, 2013

@aviario
ola paco
there is not such an event now
i'll think about it

stefanobusetto · Oct 11, 2013

@TheMightySwe
hi
- i don't think i'm going to add a tag for every row of the grid in a short time
i'll add your request to the wishlist
- every request is welcome
the longclick event is already present

aviario · Oct 14, 2013

stefanobusetto said:
@aviario
ola paco
there is not such an event now
i'll think about it

Gracias

B4A Library Grid/Table and ListView Library

Attachments

Well-Known Member

Member

Active Member

Member

Active Member

Member

Attachments

Active Member

Active Member

Active Member

Active Member

Attachments

Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Similar Threads