Hi,

> 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.

Can you try same query with some other database and/or driver? I ask
this, because there might be some bug in Borland's code. Unfortunately
I do not have neither source code of their components nor compiled
classes, so I hardly can check it.

Best regards,
Roman Rokytskyy