extracting data form multiple tables dynamically

[shafee212]

i want to extract data from multiplle files dynamically . only at run time i can specify which are the tables and which are the linked fields . it will act as a tool for data extraction.

also certain specific fields needs to be extracted

for eg i want to extract pt_part,pt_site , pt_qty_oh,pt_um from pt_mstr

and address of location form ld_det . ie both pr_mstr and ld_det are linked

so dynamically i want to extract data from these 2 tables

this was as eg .....

it could be any two tables

Also is it possble to extact data from more than two tables.

Thanks in advance.........

 

[schaapie]

Read the documentation on dynamic (Pro)datasets.
you could:
create temp-tables containing the fields needed
create a dataset contianing these temp-tables
create the data-relations between the tables
create the data-source (mapping, keys, query) you would like to perform
and then perform a fill on the dataset.
The result will be a filled dataset (containing multiple tables)