Subject Re: [IBO] Simple SQL Returns wrong fields
Author Lucas Franzen
Ed,

Ed Dressel schrieb:
> I run the following SQL with a TIB_Query:
>
> Select * from PensionPlanReleaseList where PensionPlan_ID = 211
>
> on a table that has only 2 fields but I get 3 fields as a result. It
> adds the field 'DB_KEY' to the list. I searched all my source (both
> Delphi and the database) and found nothing of that value but find
> various references to it in the IBO souce code.

Define the Keylinks properly (ie PensionPlan_ID) then you don't get the
DB_KEY.

>
> I changed the TIB_Query to a TIB_Cursor and it worked fine.

TIB_Cursor isn't buffered so there's no DB_KEY at all.

Luc.