Subject | Duplicates in Table |
---|---|
Author | wayne |
Post date | 2002-12-17T13:06:02Z |
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.
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.