Subject Duplicates in Table
Author wayne
I have since discovered duplicates in one of my tables.

this Occored while accessing the data , and by mistake came accross this as
I was
reading from first to Eof.

I then noted that there was duplicates in the PRIMARY KEY , can you believe
that.

I then had to delete it ,, but my Question is this :

Is there any tools out there ( dll ) or vcl that I could use to check the
Databse
firebird 1.0.xxx ?

Has it ever been possible to create a Database with a primary key no being
unique ?

What could have caused this.

I have restored the database from several backups. But yet the "IBX" backup
service
does not complain, and never did to my knowledge.

What should I do ,, this is live data. I have since fixed the duplicate
entries ,, but
who knows what lied beyond the mercy waters ?

Thanking you all ( merry x mas )
Wayne.