I'm using the Firebird 1.0.0.338 Beta 2 release on Windows 2000
Professional.

Sorry I forgot to mention that.

Regards,
Mike

>From: "Claudio Valderrama C." <cvalde@...>
>Reply-To: ib-support@yahoogroups.com
>To: ib-support@yahoogroups.com
>Subject: Re: [ib-support] alter table wierdness
>Date: Mon, 17 Dec 2001 00:58:31 -0400
>
>""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
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com