Parameterized SQL Joins don't appear to be working as described.

rbuser

Hello,
I am having trouble setting up master detail relationships between a
ManualSQL (Master) and a standard DataView generated sql as the detail.
I create the link on the field required and then on the SQL tab of the
designer I choose the option ParameterizedSQL. It states on the form
that ParameterizedSQL will "fire each time the master reord position
changes. SQL is augmented with a parameter linked to the master."

I can see the new parameter when viewing the magic SQL but it seems
that the sql only fires once and not with the traversal of the master
dataset. Is this a bug or am I doing something wrong?

Changing the link type to ManualSQL and qurying out all of the values
at once seems to work.

Regards,
Will.

nicocizik

Hi Will,

For future reference, please provide your ReportBuilder and Delphi
version before each new post.

Parameterized linking simply passes the linking task to the Delphi
dataset. In other words, instead of using the DataPipeline linking
which is built-in to ReportBuilder, it uses Delphi's parameterized
linking which is built-in to the TDataSet object.

This is identical to placing two TQuery objects on your form, connecting
them to your database and linking them via parameters.

rbuser

RB version is 15.03
Delphi XE

Hi Nico,
Thanks for the reply, the info was helpful. I think this is a side
affect of using daMidas as the provider for report builder. My server
is stateless and so the method for master detail linking that RB is
using does not seem to work. I will need to do some more research but I
don't think this is a report builder issue.

Regards,
Will.