Master - Detail Link Options

rbuser

Hello Support,

While linking two datapiplines in enduser builder the option in the link
dialog box for setting the "include only those records from" and the
"include all records from" doesn't make any diff in the query sent to the
server. I have clicked on the detail pipline with the Ctrl + left mouse and
changing that option still gives me an inner join no matter which is option
selected.

Using:
IBO with interbase 6
RB 7.01


Bo

rbuser

Question related to Master - Detail Link...
Is there any way to modify SQL on detail query, e.g. I have a
detail Q linked to master one, but final detail query doing
Ctrl + click shows inner join no matter what link option is selected
and I need left outer one...

Thanks !
Vadim K

nardmoseley

The option in the Link dialog box refers to the SkipWhenNoRecords property
of the detail datapipeline. It controls how the datapipeline traverses data.
It does not affect the SQL that is generated.

The Linking SQL that is generated is limited to always using an Inner Join.

One option is to manually edit the detail SQL. Then programmatically
generate the datapipeline links. The following example shows how to
accomplish this. For an enduser application you can could do this in the
Report.Template.OnLoadEnd event.

www.digital-metaphors.com/tips/LinkDADEPipelines.zip



--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

nardmoseley

See my response to the original post.

--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com