Subject | Re: [IBO] Keylinks |
---|---|
Author | Jason Wharton |
Post date | 2001-04-04T16:41:48Z |
> I've an error with TIBOQuery.IBO is just trying to nudge you into using a more workable query scenario.
>
> 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 ?
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