B4A Library Grid/Table and ListView Library

Descartex

Well-Known Member

Licensed User

Longtime User

• Aug 21, 2013

• #261

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

 

J

jrat

Member

Licensed User

Longtime User

• Aug 31, 2013

• #262

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

Active Member

Licensed User

Longtime User

• Aug 31, 2013

• #263

yust to be sure
create the table using uppercase field names

 

J

jrat

Member

Licensed User

Longtime User

• Aug 31, 2013

• #264

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

Active Member

Licensed User

Longtime User

• Aug 31, 2013

• #265

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

 

J

jrat

Member

Licensed User

Longtime User

• Aug 31, 2013

• #266

this is my code

 

Attachments

• test.zip

  8.4 KB · Views: 209

stefanobusetto

Active Member

Licensed User

Longtime User

• Sep 1, 2013

• #267

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

 

TheMightySwe

Active Member

Licensed User

Longtime User

• Oct 3, 2013

• #268

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

Active Member

Licensed User

Longtime User

• Oct 4, 2013

• #269

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

 

stefanobusetto

Active Member

Licensed User

Longtime User

• Oct 6, 2013

• #270

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;

 

Attachments

• xnGridSample4.png

  43.2 KB · Views: 630
• xnGridSample4.zip

  13.7 KB · Views: 478
• xnGridSample4_layout.png

  60.1 KB · Views: 538

Last edited: Oct 6, 2013

L

laiberica

Member

Licensed User

Longtime User

• Oct 9, 2013

• #271

Hello it is possible add or delete rows now?

 

TheMightySwe

Active Member

Licensed User

Longtime User

• Oct 9, 2013

• #272

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

 

stefanobusetto

Active Member

Licensed User

Longtime User

• Oct 10, 2013

• #273

@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

Active Member

Licensed User

Longtime User

• Oct 10, 2013

• #274

@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

Active Member

Licensed User

Longtime User

• Oct 10, 2013

• #275

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

Click to expand...

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

 

aviario

Active Member

Licensed User

Longtime User

• Oct 10, 2013

• #276

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

un saludo
Paco

 

TheMightySwe

Active Member

Licensed User

Longtime User

• Oct 11, 2013

• #277

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

Active Member

Licensed User

Longtime User

• Oct 11, 2013

• #278

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

 

stefanobusetto

Active Member

Licensed User

Longtime User

• Oct 11, 2013

• #279

@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

Active Member

Licensed User

Longtime User

• Oct 14, 2013

• #280

stefanobusetto said:

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

Click to expand...

Gracias