""Mike Arace"" <mikearace@...> wrote in message
news:F148aqEBw1ClltcNdbU0000493d@......

> Hi everyone...
>
>
> I try to run this alter table command:
> ALTER TABLE HS_GROUPS ADD CONSTRAINT GROUPS_ADMIN_USER_NAME_FK FOREIGN KEY
> (ADMIN_USERNAME) REFERENCES HS_USERS(USERNAME);
>
> As a result, I get the error:
> Attempt to store duplicate value (visible to active transactions) in

unique

> index "RDB$INDEX_16"

Which engine are you using exactly?
Platform, IB or FB, version.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing