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, my clumsy typing in the message only. The W1 is omitted from
the query's keylinks.

I am sure this problem relates to have a mulitple key becuase
removing one of the keys makes everying work fine.