VBFlexGrid Control (Replacement of the MSFlexGrid control)

[Calcu]

Hi!

2 questions, just to see if i'm doing it wrong or fine xD

1.- Best way to know what column is sorted the grid?

Actually i'm doing:

    For I = 0 To vbGrid.Cols - 1
        If vbGrid.ColSortArrow(I) <> FlexSortArrowNone Then
            ColumnOrdered= I
            Exit For
        End If
    Next I

And using the columnordered variable for something.

It's ok? there is a better way ?



aaand
2.- the best way to control the columns?
i mean, for example in a combobox, i use .itemdata(x) to control the right index of the value.
in the Grid, actually i'm filling the columns statically: vbgrid.additem xx & vbtab & yy & vbtab & zz , etc...

Is there a way to tell the grid that column 1 is "date1", where date1 is a field of my recordset ?.

this will be perfect, because then i can insert a column in the middle of the grid, without changing all the additem.. and maybe i can use the grid without the textmatrix property ? something like : vbrid.colindex("date1"). row or something like that ?

Maybe what i'm looking for is the .colkey prop ?



Thanks in advance !