Subject Re: [IBO] IB Query: Why do I sometimes get an extra field?
Author Jason Wharton
Jack,

> I am starting out with IBObjects. I am running into a small issue
> that has me stumped at the moment. When I run a query on a table
> that is something like "SELECT LastName FROM People", I get two
> fields back, LastName and another field that is a very long integer
> value.
>
> If I instead run a query like "SELECT ID FROM People" where ID is the
> primary key for the table, I just get the primary key back. Does
> this have something to do with bookmarks? Is there a way I can tell
> when I will get this second field without testing my selection to
> see if it contains the primary key?

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