Is there any way to copy T-SQL.sql.text into TppReport?
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
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
This discussion has been closed.
Comments
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