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

SQL Join Mod using RAP

edited May 2011 in RAP
Is it possible to modify the join settings of a one to many using RAP at
runtime?

Based on a report parameter passed in I either want to include all master
rows or limit the master rows only when detail is present.

I'm assuming this would occur in BeforeOpenDatapipeline but can I gain
access to the join settings from there?

Thanks.

RB 12.04 Server / Delphi 2007 / Oracle 10G

Comments

  • edited May 2011
    Hi Jon,

    Toggling the Pipeline.SkipWhenNoRecords property for the detail dataset
    should give you the effect you are after. When this property is True
    (default), all master records that do not have details will be skipped.
    When False, they will be traversed normally.

    This property can also be set in DADE in the Link dialog by double
    clicking the visual link between dataviews. (Bottom radio boxes).

    If you need to manually edit your queries further, you can use the
    TdaSQLBuilder class to alter just about any part of a query created in
    DADE from RAP.

    See the help topic on TdaSQLBuilder and it's properties for more
    information as well as the articles below.

    http://www.digital-metaphors.com/rbWiki/DADE/SQLBuilder


    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.