MSHFLEXGRID AND ADO

[anonymous]

[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

Thanks in advance

Gazal

[anonymous]

[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.

I hope this helps.