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

How to get SQL generated in report

edited July 2005 in Datapipelines
Is it somehow possible from within Delphi to get the SQL of a pipeline?
(Report Builder 9.02)

I need to pass SQL generated in report to TQuery component:

Query1.SQL.Text:= ppReport1.?????.SQL.Text

Thank you.

Comments

  • edited July 2005
    I resolve this with code below:

    var
    Comando_SQL: TdaSQLBuilder;
    begin
    Comando_SQL := TdaSQLBuilder.Create(ppReport1.DataPipeline.SQL);
    Query1.SQL.Text:=Comando_Sql.SQL.GetMagicSQLText;
    end;

This discussion has been closed.