Re: Load Data Conected with relations by David
David
Fri Sep 10 15:30:26 CDT 2004
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" <konrad007@poczta.onet.pl> wrote in message
news:uPK55P1lEHA.948@TK2MSFTNGP12.phx.gbl...
> I have DataSet with relations
> and want find function which
> loads hierarchical data into DataSet.
>
> "David Lei" <wei328@online.nospam> wrote in message
> news:e4HMIj0lEHA.952@TK2MSFTNGP14.phx.gbl...
> > Load each table individually, then create relations between tables
> > and add them to the dataset, see MS reference doc. for more info.
> >
> > "Konrad" <konrad007@poczta.onet.pl> wrote in message
> > news:uw%23tAHzlEHA.2884@TK2MSFTNGP09.phx.gbl...
> > > 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
> > >
> > >
> >
> >
>
>