New Blog Post: PDF/A and Metadata

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


  • 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


    Nico Cizik
    Digital Metaphors

    Best Regards,

    Nico Cizik
    Digital Metaphors
This discussion has been closed.