Subject Re: [IBO] TIB_Lookup and multiple keys
Author mkl20uk
--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@t...> wrote:
> >KeyLinks:
> >WAREHOUSES.W1.WHO_UNIQUE_REF = ORDERLINES.ORL_TMP_WHO_REF
> >WAREHOUSES.W1.WHO_SYSTEM_REF = ORDERLINES.ORL_TMP_WHO_SREF
>
> Doesn't look right. Take out the "W1" - it doesn't belong here. A
Keylink
> has to evaluate to a valid WHERE clause segment and refer to the
actual table.
>
>
Sorry, the W1 is just a typing mistake in the message, the KeyLinks
are correct.

I think this problem has something to do with multiple keys because
it works fine if I use a single key.

Sorry if this message appears more than once, seem to have problems
posting a reply at the moment.