Thank you Martijn for your answer; I found the problem and it was my error.

Regards,
Guillermo

""Martijn Tonies"" <m.tonies@...> wrote in message
news:011a01c25e75$697dc570$0a02a8c0@seal...

> Hi,
>
> > I have a table named REGOPER_PART with 18,000 records. When trying to
> create
> > a foreign key that DID NOT exist, I get:
> >
> > This operation is not defined for system tables.
> > unsuccessful metadata update.
> > STORE RDB$RELATION_CONSTRAINTS failed.
> > attempt to store duplicate value (visible to active transactions) in
> unique
> > index "RDB$INDEX_12".
>
> Without the proper metadata and statements, it's hard to say -
> probably someone else who knows the engine knows what index
> that is :)
>
> You're sure you didn't name the constraint to some existing constraint?
>
> > When trying to check Indexes for this table using IBConsole, I get:
> > SQL ERROR CODE -204
> > Ambiguous field name between table RDB$INDICES and table
> RDB$INDEX_SEGMENTS
> > RDB$INDEX_NAME
> >
> > I gbaked and restored it, and the problem is still there.
> >
> > whats wrong?
>
> IBConsole is no longer compatible with Firebird. You really should
> try one of the other tools available.
>
> Download a copy of Firebird Workbench (shareware) at www.upscene.com
> or give a free tool a try - see www.ibphoenix.com section "contributed
> downloads" for a list.
>
> With regards,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase
> http://www.upscene.com
>
> Firebird Workbench - the developer tool for Firebird
> http://www.upscene.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
>
> 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/
>
>
>