I am using Firebird 1.5 and I am using Borland's querydatasets
instead of java ResultSets. I am encountering a curious error when
I run a specific select statement.

Example:

Select columnname from tablename where primarykey = 'value'

When this statement is executed, the querydataset returns the value
of the primary key in its first position and then the value of the
selected column next. To my knowledge it should only return the
value of the column I am searching for.

This only occurs when my Where criteria involves the primary key,
otherwise it works just fine.

Can anyone shed any light on why this may be occurring.

Thanks in advance,

WB

P.S.
I am using the latest Firebird drivers and java 2 sdk.