Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Is there any way to copy T-SQL.sql.text into TppReport?

edited July 2004 in End User
Hi,
Is there any way to copy T-SQL.sql.text into TppReport?
I use query designer in TppReport to generate a sql and also connect to the
TppDBText by each DataField.
The problem here is I have generated a sql.text in T-SQL at run-time and
wish to show in the dbGrid and report also.
Is there any way to copy T-SQL.sql.text into TppReport like
TppReport.datasource.sql := tsql.sql.text ???

Any help is appreciated
Cheers
Brian

Comments

  • edited July 2004

    You need to extract the TdaSQL object associated with the DataView. Here is
    an example that you can download....

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

    --


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.