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

Optaining sql textst from TdaSQLBuilder.

edited March 2009 in Component Writing
Good afternoon,

For a component I am writing I need to optain the sql textst from a report.
I can optain the first stream by calling fsqbuilder.sql.sqltext.text.
But If a report has more than one data stream I only get the first one.
How can I get the other one's?

Best regards,
Rob Nowee

Comments

  • edited March 2009
    Hi Rob,

    If a report contains multiple dataviews in DADE, they will each create their
    own SQL object. The TdaSQLBuilder class can only access and alter a single
    SQL object at a time so you would need to create multiple to gain access to
    multiple pipelines (dataviews).

    The separate TdaSQLBuilder objects will need to be created with separate
    constructor parameters (TppCustomReport, TppDataPipeline, or TdaSQL
    objects).

    --
    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.