Dynamic Query Generation

[newtonsapple]

Hi all,

is it possible to write back on database dynamically based upon the Report Query generated for the Report.

EG: I have one Report which is having n no of prompts. I have implemented dynamic query generation for the Report based upon the Prompt selected by the User at run time. Suppose I have 4 tables A--B--C--D join in the Order as shown. Now based upon the Prompt selected from all the Fields derived from tables, my Report is generating the Query. Now is there any possible way to use this query and pass it to a database procedure to insert a data in a certain table.

Thanks a lot .....