Does the table have a primary key? Are you selecting it?

Does this statement return any rows?

SELECT <PK>
FROM <Table>
GROUP BY <PK>
HAVING COUNT(*) > 1

Set

--- In firebird-support@yahoogroups.com, "petesouthwest" wrote:
> Hi
>
> There are no triggers or cascading foreign key constraints to tables
> with ON DELETE triggers.
>
> Its bizzare, I cant even edit the data in the table....
>
> Pete