[All]
Returning duplicate rows with SQLPrimaryKeys
Abstract: Returning duplicate rows with SQLPrimaryKeys
Problem:
When using SQLPrimaryKeys to return the primary key of a table, there are
duplicate rows returned where it should be just one unique row.
Solution:
IB V4.x
Visigenic InterBase ODBC driver V1.00.0809
This is a Visigenic ODBC bug (Visigenic bug #7222, IB bug #8428). The
problem driver is 1.809, it was fixed in driver 2.00.901
If the customer can't get/install the updated driver, the workaround is to
define a unique field name within the table.
