If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

MSHFLEXGRID AND ADO

[Originally posted by Arif]

Hi Grid experts

I need to disply data Hierarchaly in MSHFLEXGRID using ADO Recordset.
Can someone provide me a working example. I have looked at the Shape
Command help in MSDN, i tried using the same example but it doesn't work
, it gives provider's error. I am using Access 2000 and VB 6.0 and my table consists
of following fields:

User_Name,
Date,
Amt_Paid,
Amt_Bal

I want the query to be linked on the basis of User name coz one user can
have balance amt's on multiple dates. So pls. help me

Re:MSHFLEXGRID AND ADO

[Originally posted by Peron]

Hi Gazal,

I'm not a grid expert but i used it and I remember
the next:

1.- If I want to use a hierarchical Flexgrid (HFG) first I have to write a hierarchical SELECT sentence.
2.- If I want to do a hierarchical SELECT sentence I have to use the Provider (or DataProvider, I don't remember exactly) MSDataShape.

MSDataShape is very important!! if you don't use it you cannot use hierarchical sentences.