How to create autosearch fields from code (with a little twist) ....

rbuser

Ok, this is my scenario:

My users have two applications, the first application is an end-user report
solution, and the second one is a business application. Well, in the
business application they have a grid with information about people. When
they select a person, they also select the name of a report (these reports
are the one created in the end-user app). Now, I have to create autosearch
fields in order to get the report for the specific selected person. So far
so good.

Now, suppose that in the report solution I create two reports (R1 and R2) ,
each one based on a different table (say T1 and T2). When I select the
report in the business app, I need to create the autosearch field ..... the
problem is, how do I now what table is the autosearch field for??? If I
select R1 then that table for the autosearch field is T1, and the same goes
to R2.

Is possible to know what tables are used in a report? My first tought is
about getting the tables, but I don't know

Any idea? Thanks in advance
Luis Xim?nez

nardmoseley

The following example shows how to extract the TdaSQL object from a
DataView. The TdaSQL object contains the description of the SQL.

www.digital-metaphors.com/tips/ExtractSQLObject.zip

--

Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com