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.