I think Shape dataset is what you are looking for.
use something like this in store procedure to return a
Hierarchical dataset.
SHAPE {SELECT au_id, au_lname, au_fname FROM authors}
APPEND ({SELECT au_id, title FROM titleauthor TA, titles TS
WHERE TA.title_id = TS.title_id}
AS title_chap RELATE au_id TO au_id)
"Konrad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have DataSet with relations
> and want find function which
> loads hierarchical data into DataSet.
>
> "David Lei" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Load each table individually, then create relations between tables
> > and add them to the dataset, see MS reference doc. for more info.
> >
> > "Konrad" <(E-Mail Removed)> wrote in message
> > news:uw%(E-Mail Removed)...
> > > Hi
> > >
> > > I have typed DataSet.
> > > How to load all Connected data to DataSet.
> > > Say I load one record from table1 and it is
> > > connected to table2. How to simply load it too
> > > to DataSet. I simply want to load all tree
> > > connected data.
> > >
> > > Thanks
> > > Konrad
> > >
> > >
> >
> >
>
>
|
Similar Threads
