Modify Sql script in DADE

rbuser

Hi,

I have developed some reports with DADE.
The queries have been realized with the query designer of Report Builder.

I have the necessity to modify only the table name of the script and not
modify the fields ,the criteria ecc..

Ther'is a simple way to modify the query without losing the support of the
query Designer.

--
Luca
Padova (IT)

nicocizik

Hi Luca,

ReportBuilder 9.0x includes the TdaSQLBuilder object wich makes if very easy
to access and alter the SQL object in DADE. Take a look a the TdaSQLBuilder
topic in the ReportBuilder held for a detailed description and examples on
how it is to be used to add, change, and update your SQL code in DADE at
runtime.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nicocizik

Hi Luca,

I apoligize, I did not fully ready your initial post. It is not possible to
simply change the table name with the SQLBuilder. In this case you will
need to complete delete the existing table from the data module and create a
new data view with the new name. This can be done using the SQLBuilder.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi.

I have understood.

So if I have to modify a query of the type:

Select IdCli,nom,prenom from Table1
with
Select IdCli,nom,prenom from Table2

I have to make all the query ( define table and fields ).

It's Right?

nardmoseley

Yes. As an example, first play with using the Query Designer to modify the
table name. The only way to do it is to use the Tables tab to remove one
table and then add another. Once a table is removed, all of the select
fields that belong to the table are also removed.

The TdaSQLBuilder works in the exact same manner. It is a runtime interface
that provides the same operations as the Query Designer.