Subject | RE: [IBO] IB_Query/SP/KeyLinks |
---|---|
Author | Alan McDonald |
Post date | 2004-10-29T11:14:19Z |
> With a SP as your detail set, there is no cursor, so there can'tI told a fib - this is what I should have said
> 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 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?
Alan