Subject RE: [IBO] IB_Query/SP/KeyLinks
Author Helen Borrie
At 09:14 PM 29/10/2004 +1000, you wrote:

> > With a SP as your detail set, there is no cursor, so there can't
> > be a WHERE
> > clause. Even if you have the parameters right (which you
> > haven't), the SP
> > has to execute each time the master scrolls. To make this work, you have
> > to write a SSP that takes only the bound master field(s) as its input.
> >
>
>I told a fib - this is what I should have said
>
>I have an IB_Query set with the following SQL
>SELECT FIELD1, FIELD2, FIELD3 FROM LOAN_S_ALL(:FK_SECCODE) WHERE ...
>I have the KeyLinks property set to 'FIELD1'
>and the MasterParamLinks set to 'FK_SECCODE=FK_SECCODE'
>where this field is present in the mastersource datasource dataset.
>
>the only thin missing is the Mast. prefix - is that all that's going wrong?

It's not a prefix - it must the qualifier of the table the master link
belongs to.

The amended settings look correct except for the missing table qualifier on
the right. The key thing with MasterParamLinks is to link a Param on the
left with the bound (master) field on the right.
c.f the alternative way to do master-detail binding, which is to have the
detail field (from a non-virtual table) on the left and the bound master
field on the right.

Helen