Load Data Conected with relations

  • Thread starter Thread starter Konrad
  • Start date Start date
K

Konrad

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
 
Load each table individually, then create relations between tables
and add them to the dataset, see MS reference doc. for more info.
 
I have DataSet with relations
and want find function which
loads hierarchical data into DataSet.
 
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)
 
Back
Top