Modify SQL Text

rbuser

How can i modify the SQL Text of a report, not only when generating the
report data (wich i know how to do), but for once.

Like:

Before viewing the report?s SQL: SELECT * FROM CUSTOMERS
After modifications : SELECT * FROM CUSTOMERS ORDER
BY NAME

If i restart the application, and open the report, the sql text would be
'SELECT * FROM CUSTOMERS ORDER BY NAME'. So, i change the sql and keept it
for future viewing.

Is this possible?

nardmoseley

1. RB 9 includes a new TdaSQLBuilder class that can be used to modify the
TdaSQL object associated with a dataview.

2. To make changes permanent, you need to save the report definition. If you
are storing reports in .rtm files or a database, try calling
Report.Template.Save.

rbuser

Thank you Nard.

It works!