It will simply use the DB_KEY if it doesn't find the primary key columns in
the select list. If you add the primary key columns to your select list it
won't need to use the DB_KEY and simply make use of them instead.

Jason Wharton
www.ibobjects.com

----- Original Message -----
From: "jrodenhi" <jack@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, November 21, 2003 3:49 PM
Subject: Re: [IBO] IB Query: Why do I sometimes get an extra field?


> --- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
> Jason,
> Thank you. Your comments are very helpful. I will check when I get
> back to this app, but I thought I did have a primary key on this
> table. Is it possible that I would get the system DB_KEY if I query
> a table that has a primary key but I do not include the primary
> key in my query?
>
> I'm just curious. I should be able to fix this either way with the
> information you gave me.
>
> -Jack
>
> > Apparently you don't have a primary key on that table. By having
> > KeyLinksAutoDefine set to true IBO will include the system DB_KEY
> for the
> > record in your output. If you don't want this, then you can set
> > KeyLinksAutoDefine to false.
> >
> > HTH,
> > Jason Wharton
> > www.ibobjects.com