Subject | Re: [IBO] TIB_Lookup and multiple keys |
---|---|
Author | mkl20uk |
Post date | 2002-03-29T05:35:32Z |
--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@t...> wrote:
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.
> >KeyLinks:Keylink
> >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
> has to evaluate to a valid WHERE clause segment and refer to theactual 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.