Hi Andrew,

Your problem it's a know bug in IBConsole. Nothing you can do about it.

Some people call this 'just a bug', another call it a 'political' bug. Long
Story.

Artur

----- Original Message -----
From: "csswa" <csswa@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, April 30, 2002 9:15 PM
Subject: [ib-support] Ambiguous field name between table


> Hello all.
>
> I'm trying to pinpoint a DML code error in a script. The script
> executes without problem to build the db, but when I try to view
> indexes via IBConsole it gives me:
>
> Dynamic SQL Error
> SQL error code = -204
> Ambiguous field name between table RDB$INDICES and table
> RDB$INDEX_SEGMENTS
> RDB$INDEX_NAME
>
> However, IB_SQL has no problem showing all indexes for tables.
>
> One thing I'd like to check is:
>
> ADD CONSTRAINT ACT_PARENT_FK
> FOREIGN KEY (ACT_PARENT_FK) REFERENCES T_ACTION (ACT_PK)^
>
> Is there a problem giving a constraint the same name as an existing
> field?
>
> Regards,
> Andrew Ferguson
> -- Finding work for idle hands.
>
>