Subject | Simple SQL Returns wrong fields |
---|---|
Author | Ed Dressel |
Post date | 2004-09-23T17:27:52Z |
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.
I changed the TIB_Query to a TIB_Cursor and it worked fine.
Any ideas why it's adding the field to the list?
(The "PensionPlanReleaseList " is a many/many table listing ID's
from two tables).
Thanks
Ed Dressel
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.
I changed the TIB_Query to a TIB_Cursor and it worked fine.
Any ideas why it's adding the field to the list?
(The "PensionPlanReleaseList " is a many/many table listing ID's
from two tables).
Thanks
Ed Dressel