Templates

rbuser

Dear all,

First things first Great Product Guys keep up the good work

Now my little problem is this:-

I have setup a end user solution using interbase and delphi 6. It works
great. Now once i have created the template and stored it into the database
is there anyway i can change the SQL at Run time. Thats it.

Thanks

Dean.

digitalmetaphors

Yes, you can pull out the dataview's TdaSQL object and change the objects
that are defined on the dataview. This way the SQL which is generated will
be different. This is the preferred way rather than editing the SQL text
directly, as you'll lose the query tools if the SQL text is edited. Here is
an example of modifying the objects on the dataview.

I've updated the ExtractSQLObject tip to use subreports dataviews.
http://www.digital-metaphors.com/tips/ExtractSQLObject.zip

Cheers,

Jim Bennett
Digital Metaphors