Subject | RE: [IBO] IB_Query/SP/KeyLinks |
---|---|
Author | Helen Borrie |
Post date | 2004-10-29T11:44:20Z |
At 09:14 PM 29/10/2004 +1000, you wrote:
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
> > With a SP as your detail set, there is no cursor, so there can'tIt's not a prefix - it must the qualifier of the table the master link
> > 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?
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