Subject | RE: [IBO] IB_Query/SP/KeyLinks |
---|---|
Author | Alan McDonald |
Post date | 2004-10-29T11:17:19Z |
> SELECT FIELD1, FIELD2, FIELD3 FROM LOAN_S_ALL(:FIELD3)I'm still a bit confused though - you say at first there can't be a where
> 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
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