FiveTech Support Forums

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 ?

Mr Silvio

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

Silvio wrote: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 ?

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