Subject RE: [IBO] IB_Query/SP/KeyLinks
Author Alan McDonald
> SELECT FIELD1, FIELD2, FIELD3 FROM LOAN_S_ALL(:FIELD3)
> KeyLinks property set to 'FIELD1'
> and the MasterParamLinks set to 'FIELD3=Mast.FIELD3'
> where "Mast" is the name of the table that has FIELD3 either as
> its primary
> key or as another unique key.
>
> Helen

I'm still a bit confused though - you say at first there can't be a where
clause. but now you say FIELD1 can be the keylinks.
Now - in this case FIELD1 is definitely a PK of the underlying table source.
A SELECT * FROM LOANS_S_ALL(:FK_SECCODE) WHERE FIELD1=1
would return one and only one record.
But does IBO try to refresh the one buffer record with this SQL?
Alan