SQL Join Mod using RAP

rbuser

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

nicocizik

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