Hi All, I dont know whether this is possible or not, but if anyone has an idea can he please let me know how it can be done...
I am creating a data Model.(Replication of the database.) Now the user selects number of columns from two or more tables. Once the user clicks submit I have to create a query in the fly from whatever columns the user has selected..
Can this be done??If yes how can we do this??
Has any one built a query on the fly ? Thnaks a lot for your help.
Adrian, I did that once in a data warehousing class. The hardest part was figuring out what tables are required to join the selected tables in the query. Also, try to come up with a distinct prefix for each table. Once you have the joins, it is mostly a matter of assembling the clauses.