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.

Jason Wharton
CPS - Mesa AZ