Home› DADE
ReportBuilder 22.04 now available including Delphi 12.1 support!
New Blog Post: Helper Routines

Report SQL

rbuserrbuser
edited November 2008 in DADE
I am using Delphi7, ReportBuilder 10.09, and FibPlus. How would I pull
the SQL from the report?

Thanks,
Nick

Comments

  • nicociziknicocizik
    edited November 2008
    Hi Nick,

    If you just need the SQL text, you can access the SQL object using the
    Report.Datapipeline.SQL property. This property is a TObject so it will
    need to be type cast.

    uses
    daSQL;

    begin
    lsSQLText := TdaSQL(Report.DataPipeline.SQL).SQLText;
    end;

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.