sorry, just TEST
""wayne"" <waynef@...> wrote in message
news:000c01c2a5cd$0ced4430$3200a8c0@......

> 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.
>
>
>
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>