SAMPLE OF A TREEVIEW WITH MDB

[Silvio]

TO OPEN A FILE i MADE :

oRs = CREATEOBJECT( "ADODB.Recordset" )
TRY
oRS:Open( "SELECT * FROM CATEGORIE ORDER BY SCATEGORIE", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ecom.mdb", 1, 3 )

CATCH oErr
? oErr:Description
RETURN NIL
END TRY


NOW i MUST CREATE A LISTBOX TREEVIEW WITH THIS MAP

sCATEGORIE
-----> CATEGORIE
-----> CATEGORIE
sCATEGORIE
-----> CATEGORIE

HAVE YOU ANY SAMPLE ?

[nageswaragunupudi]

Mr Silvio

There are several ways. I shall post two alternatives. Pl give me some time

[Enrico Maria Giordano]

TO OPEN A FILE i MADE :

oRs = CREATEOBJECT( "ADODB.Recordset" )
TRY
oRS:Open( "SELECT * FROM CATEGORIE ORDER BY SCATEGORIE", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ecom.mdb", 1, 3 )

CATCH oErr
? oErr:Description
RETURN NIL
END TRY


NOW i MUST CREATE A LISTBOX TREEVIEW WITH THIS MAP

sCATEGORIE
-----> CATEGORIE
-----> CATEGORIE
sCATEGORIE
-----> CATEGORIE

HAVE YOU ANY SAMPLE ?

You can use TTreeView class.

EMG

[nageswaragunupudi]

Mr Silvio

I sent a small sample to your personal email. Yes it uses TTreeView also as one of the alternatives.

Incidentally there is another way of reading parent - child relationships, which is called DataShaping. I did not include this, because it is more advanced and complex