Subject Re: [IBO] Keylinks
Author Jason Wharton
> I've an error with TIBOQuery.
>
> I use a simple TIBOQuery like 'SELECT Field1 FROM T1' to load a list
> of values. It works well.
>
> If I want to suppress the current record of the selection with a
> statement like this :
>
> 'SELECT Field1 FROM T1 WHERE PK <> a_value',
>
> I get an error : "Invalid KeyLinks entry : T1.PK"
>
> If I modify the statement in order to have PK in selected fields, it
> works.
>
> An other solution is to set KeyLinksAutoDefine to false.
>
> But why ?

IBO is just trying to nudge you into using a more workable query scenario.
By not having any KeyLinks this limits the effectiveness of certain things
with IBO. In your case it probably isn't a big deal since you are just
grabbing a list of items.

When you use the KeyLinks property you need to actually use those columns in
the select list.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com